Quick...

sandeep.patel1 (3/27/2014)

---

Hi Eirikur Eiriksson,

I want to assing my Aggregate transformation output(Which Returns only one value like 5.50) into a Variable.

How can i do this.

I already created a variable in Package...

Well, this is what I got when I tried that:

Error1Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)).G:\Mhub_Operations\DATA\SSIS\Archive_Snapshots\Weekly_FullSnapshots -...

Create a variable which has high enough scope for all the tasks you want to use the variable in. Then assign the initial value to the variable where the value...

The way I would do this is :copy the package file, open the package in a text editor, delete everything including the tags between any instances of <DTS:ConnectionManager> and <DTS:ConnectionManager...

ErikMN (3/27/2014)

---

Thanks for the reply, but I think you're missing one part of my scenario or I'm not quite understanding your answer. The problem with your answer is that...

One suggestion is to use derived column and the replace function inside the left function.

kmdavisjr (3/27/2014)

---

Hi Everyone. I have full server rights (OS and SQL) on the host. The screenshot is a capture of the error I am getting. Full text...

You can query the xml package file to list all connections, look at this thread for more info;

http://www.sqlservercentral.com/Forums/Topic1380488-21-1.aspx

Quick question, are you using full-text search on the server?

Edit:

The server is pretty smart when it comes to interpreting even the strangest of user's naming :w00t:

As an example, this...

No "clean" function that I know of, manual labour I am afraid.

To speed the process, use the property (F4) window, lists connections etc. of data flow and control...

You could (protect your identity by 😉

1. Script the database

2. Run the create table part only at the destination

3. Use Import wizard to transfer the data, enable identity insert...

My 2 cent;

An apostrophe is a valid character in a surname so that should be catered for.

Hi,

You can use the ROW_NUMBER function to produce the desired results.

Is this what you are looking for?

SELECT

A.[CHAIN VALUES]

,A.TIPE

,A.CORR

,A.OPERATION_ID

,A.[DUE DATE 1]

,A.[DUE DATE 2]

FROM (

SELECT

ROW_NUMBER() OVER

(PARTITION BY...

The N denotes the N(VAR)CHAR type, without it the N it would be (VAR)Char.

😎