Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
yasminpriya
Gaurav Pal
Ram
christianasteves

### How to load a new table with the value of a variable from SSIS package?

Hi, i have two variables in a SSIS package Var1 and Var2. Both of these variables have values. is there any way i can put the values of these two variables in a new table? e.g In New table col1 having value of Var1 and col2 having value of Var2. Thanks

### How to send record(which is a weblink) from a table to the value of the variable in SSIS package and

Hi Folks, I have table called Table1 with columns, col1 and col2 with col1 having weblinks for the report and col2 the name of the report. Now, i have a package with a variables var1 and var2 which should get the col1 and col2 values respectively from table1 and send it through an email. if the weblink gets updated in the table, package should send the updated link. i know the reverse way of it but trying to do somethig like this. Appreciate any help from you guys. Thanks

### Weird behavior

I've made this "Minify" class that inherits from MemoryStream and I want to use it to minimise the amount of whitespace in for example css and javascript files. To begin with I'm not doing anything complex just a simple replace.using System;using System.Collections.Generic;using System.Linq;using System.IO;using System.Text;using System.Web;using System.Text.RegularExpressions;namespace Output{    public class Minify : MemoryStream    {        private Stream stream = null;        public Minify(Stream stream)        {            this.stream = stream;        }        public override void Write(byte[] buffer, int offset, int count)        {            string content = UTF8Encoding.UTF8.GetString(buffer);            content = LimitWhitespace(content);            stream.Write(UTF8Encoding.UTF8.GetBytes(content), offset, UTF8Encoding.UTF8.GetByteCount(content));        } &nbs

### EXPERT: avoiding weird refresh behavior of Eval method in a tabpanel

I have this control in a detailsview:<asp:DropDownList ID="ddlEventStartDay" SelectedValue='<%#Cdate(Eval("startdate")).Day %>' CssClass="textbox" runat="server">    <asp:ListItem Value="1" Text="01" />    <asp:ListItem Value="2" Text="02" />    <asp:ListItem Value="3" Text="03" />    <asp:ListItem Value="4" Text="04" />    <asp:ListItem Value="5" Text="05" />    <asp:ListItem Value="6" Text="06" />    <asp:ListItem Value="7" Text="07" />    <asp:ListItem Value="8" Text="08" />    <asp:ListItem Value="9" Text="09" />    <asp:ListItem Value="10" Text="10" />    <asp:ListItem Value="11" Text="11" />    <asp:ListItem Value="12" Text="12" />    <asp:ListItem Value="13" Text="13" />    <asp:ListItem Value="14" Text="14" />    <asp:ListItem Val

### weird Rating Control behavior

Hi folks! :)I have Rating control on my page. The page is a subpage of nested master page. On that page is updatepanel and wizard with TemplatedWizardStep inside it and inside TemplatedWizardStep is Rating Control.Master.Page -> NestedMaster.Page -> Content.PageI allso have googlemap inside that wizard(on different step) so i need to register google initialize() for it to work.So by registering googlemap like example below Rating Control freezes. Private Sub ScriptManager1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles ScriptManager1.Load ScriptManager.RegisterStartupScript(Page, Page.GetType(), "onload", "initialize()", True) End Sub But if i include script tags in string like example below, Rating Control does not freeze. Private Sub ScriptManager1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles ScriptManager1.Load ScriptManager.RegisterStartupScript(Page, Page.GetType(), "onload", "<script>initialize()</script>", False) End Sub Everythnig works, but i wonder, WHY :) Why is Rating Control freezing in sample1?

### how to store the values in a object variable (package level scope) in a script component

I have declared a variable of object type with package level scope.  I want to assign values to this variable inside a script component.  My object should hold 5 columns in a row.  How to implement this ?

### How to get the Package level Variable collections (Global Variable) in Script Task

Hi All,

I have the requirement like read all the Variables in Script Component Task, which includes variables available at package level and their values, global variables declared at package.

Currently are two ways to read the variables but which are not suitable for my requirement

1) Mentioning the variables at Script designer window as ReadOnlyVariables or ReadWriteVariables

<

### weird behavior in SSMS - backslash (\) is getting displayed as (#)

I'm experiencing some weird behavior in SSMS for SS2008.  When I create a new query and type the backslash (\) key a pound(#) symbol is displayed instead in the query window.  I've never experienced this behavior in SSMS 2005 before.  This is the first time I'm using SSMS 2008.  I work with a few developers who also use SSMS 2008 and they have no idea about this either.  Any idea whaat might be causing this behavior and any idea how I can fix this?  I'm using Windows 7 and the backslash (\) symbol displays as expected in other applications (Notepad, VS2010, etc).

### its showing weird binary data from the BDC data column in list

Hello Gentlemen,

Here I am experimenting the BDC with a simple example of pulling distinct data from a sql server 2005 to a sharepoint list column "SELECT distinct Color FROM Product" .

BlueÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
GreenÃÂ ÃÂ ÃÂ ÃÂ
Murali
redÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
WhiteÃÂ ÃÂ ÃÂ ÃÂ
Yellow

when i configured the bdc using Business Data List the data showing correct. But when I use this it in a list column with bdc data type itsÃÂ returnig me the binary type of data.
ÃÂ
__bk82007400270056005600e60002000200020002000200
No exact match was found.

However in the bdc picker the data is displaying properly. The data type in sql is nvarchar. I tried changing different data types but its showing the same kind of it.

Here is the BDC:

### OLE DB Destination SQL command - how can I select from recordset variable?

How do I insert records from connection1 into a a table with the same name on connection2 where the records in connection2 do not already exist?

The approach I'm trying is this: I have an OLE DB Source that selects records from connection1 (successfully). The flow into a recordset destination in the Data Flow. But I can't figure out how to select from this recordset using the FROM CLAUSE of a SQL Command in the OLE DB Destination component. Can someone point me to an example of this?

It seems like this would be a common task but I can't find any examples.

msdn has a code sample illustrating the use of SetPrincipalPolicy. I copy the code and the output below:

using System;
using System.Security.Principal;

{
ÃÂ ÃÂ ÃÂ  static void Main(string[] args)
ÃÂ ÃÂ ÃÂ  {
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  // Create a new thread with a generic principal.
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  t.Start();
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  t.Join();

ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  // Set the principal policy to WindowsPrincipal.
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  AppDomain currentDomain = AppDomain.CurrentDomain;
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  currentDomain.SetPrincipalPolicy(PrincipalPolicy.WindowsPrincipal);
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  // The new thread will have a Windows principal representing the
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  // current user.
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  t = new Thread(new ThreadStart(PrintPrincipalInformation));
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  t.Start();
ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ  t.Join();

### weird behavior in SSMS - backslash (\) displays as (#) in query editor

I'm experiencing some weird behavior in SSMS for SS2008.  When I create a new query and type the backslash (\) key a pound(#) symbol is displayed instead in the query window.  I've never experienced this behavior in SSMS 2005 before.  This is the first time I'm using SSMS 2008.  I work with a few developers who also use SSMS 2008 and they have no idea about this either.  Any idea whaat might be causing this behavior and any idea how I can fix this?  I'm using Windows 7 and the backslash (\) symbol displays as expected in other applications (Notepad, VS2010, etc).

### SSIS Parent/Child Package variable passing

Hi

I have having trouble getting my hands around how toÃÂ retrieve variables from a parent package.ÃÂ  I read about the Environment variables and Configuration File at the parent package level and the Parent Package variable at the child level.

Here are my questions:

1.ÃÂ  Can you only store/retrieve 1 variable in a config file at a time?

2.ÃÂ  Does the child package have to define the variables and if so, do they have to be the same names as the parent package?

This seems so more more complex then the DTS2000 way of passing variables to and from packages.

Any help would be appreciated.

ÃÂ

ÃÂ

### How to send any collection object from .NET Application to object variable created in SSIS Package

HI All,

I have a question regarding SSIS -- How to send list object from .NET Application to object variable created in SSIS Package. In List object there are one lack records stored..This list object needs to be passed to SSIS Package. Please reply me back with any suggestion/solutions ...Required ASAP.

Thanks,

vineesh1701

### Error while trying to assign a value to a Read Write variable in SSIS package script component

Hi,

I am trying to develop a SSIS package which will read the records from the flat file and insert them into a destination table. I have some validations written in script component. I have declared two Read Write variables with package level scope. when i try to assign a value to the variable in the script component and run the package, the package throws me an error "The collection of variables locked for read and write access is not available outside of PostExecute".

Thanks

### Cant see package level variable in script component

I am currently having a issue accessing a package level variable.

My package level variable is called RecordSet1 and type object.

I was able to use a Data Flow and populate the variable with data with a record set destination.

So, now I am writing a script component that makes a recordset as a source(I am new to ssis and I know this has performance issues, I am only doing this to get familiar with scripting cause my manager told me too) So I am not able to access any of the variables. My code is below. I am getting a error on this.Variables.RecordSet1. I looked all over online and unable to really find a solution. I know in script component, you can use the this.Variables.VariableName to access the variables but even my intellisense isn't showing anything.

Error 1 'Variables' does not contain a definition for 'RecordSet1' and no extension method 'RecordSet1' accepting a first argument of type 'Variables' could be found (are you missing a using directive or an assembly reference?) C:\Users\Dhinesh\AppData\Local\Temp\SSIS\ee6fc0aaa4f447e0b024451e97f51dec\main.cs 42 39 sc_95443d5e406b44d

### Weird application behavior -- Action required to trigger service response otherwise the application

Hi,

I am a WCF beginner and is trying out with a basic host service with callbacks to the client.

My code works wonders if my client app is a console.exe but when I transferred the code to a Windows Form app, the application will freeze.  But if I right click on the form window task bar, the code suddenly goes through and it would work...

Is there anything wrong with this?

The service is hosted on IIS

Here is my Service code:

[ServiceContract(CallbackContract = typeof
(IChatCallBack))]
public
interface
IChat
{
[OperationContract]
void
Talk(string
msg);
}

[ServiceContract]
public
interface
IChatCallBack
{
[OperationContract]
void
OnCallBack(string
msg);
}



Implementation:

[ServiceBehavior(
ConcurrencyMode = ConcurrencyMode.Reentrant)]
public
class
Chat : IChat
{


Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All