jgenshlea (5/14/2009)

---

I have a very similar problem. I dynamically construct source and destination paths which works perfectly on with the copy method. If I change the method to move...

jcwilliams (5/14/2009)

---

Ramesh (5/14/2009)

---

I don't know why it is not working at your end, but it works fine at my machine. I've attached a sample package that I've created.

Let us...

If you could have read Books Online, you would surely be able to solve it on your own. Anyways, here is the solution for the sample data provided by...

When using IN clause the sub-query must only return a single column but in this case "*" is used.

Modified Query

Insert Into tPM_Cmptc_Cat_Skill_Codes (compcatidno, skillcodeidno, fromeffectdate, toeffectdate)

select '-10001', a.skillcodedomainidno, a.skillcodefromeffectdate,...

Look for ROW_NUMBER() function with PARTITION BY clause in Books Online.

I'm having a bad day today:hehe:, most...

How are you setting the named range in excel destination connection?

I think it should be set to "Command" and the command text should set to "SELECT * FROM...

You are welcome, and thank you for the compliment.

I don't know why it is not working at your end, but it works fine at my machine. I've attached a sample package that I've created.

Let us know if...

I suspect there's something missing here;-)

Are you sure that you wanted to replace all zeros with empty strings or just the leading zeros?

Okay, I've found the place where the problem lies. Its "Operation" property of "File System Task" which should be "Rename file" instead of "Move file".

"Move file" Operation does not...

WHERE Clause needs to be added to the PivotedColumnSQL as well.

Revised Code:

DECLARE @PivotedColumnSQL VARCHAR(MAX),

@sql NVARCHAR(MAX),

...

I don't think there's any issue with the expression but could be a problem with the destination connection settings. Can you post the screenshot of the destination connection as...

I suggest you do it without using connections.

1. Create variable "SourceDir" to hold source directory

2. Create variable "SourceFilePath" to hold current file path

3. Create variable "TargetDir" to hold target directory

4....

I think the problem is with the variable mapping of for each loop container...

Shouldn't this "Variable Mappings = User::Dest_file" be "Variable Mappings = User::Src_File"?