Glad you were able to get it working.

Resender (9/26/2013)

Last week I made a package in which it worked no problem & converted into a template.

This week whenever I try and test it I get an error that...

I'm fairly new to this, also. A reference I've found very helpful is Star Schema Complete Reference by Christopher Adamson. It's been a good companion to Kimball's Toolkit....

The article suggested by Chrissy321 should walk you through how to do a dynamic expression for...

axes2000 (9/19/2013)

---

hi all,

I never found the SSIS 2008 R2 section so I am posting this here since it really is of somewhat general interest:

how do I convert a date in...

Glad to hear you got it working. Thanks for reporting back your approach.

J M-314995 (9/5/2013)

---

After nightly system processing, 7 date fields need to be "todays" date and 2 of the date fields need to be "yesterdays" date. If all 7 don't...

tinnusqlserver (9/8/2013)

---

Please Advise!!

I have to import data from a .txt file using SSIS package into sql server.

HOW CAN WE FIND(KNOW) THE

a) Format

b) Text Qualifier

c) Header row delimiter

d) Row Delimiter

e) Column...

Koen Verbeeck (8/9/2013)

---

kl25 (8/8/2013)

---

Interesting topic. ...

Interesting topic. I've been struggling...

A couple of cautions. I wouldn't recommend just leaving the package as you find it from the wizard. Update names, use...

RedBirdOBX (8/6/2013)

---

Every day, I connect to both our internal DB and our external (web site) DB using SSMS. I then go through Import/Export Wizard and simply import the data...

ugh3012 (8/5/2013)

---

I have a SP that does bunch of stuff. It ends with a select statement from a temp table. How do I invoke that SP and send the output...

Is it possible that there is a lag between when the file is created...

Final:-D:\test20130724_230456_662000000.xls which having expression

"D:\\test"+Replace(Replace(Replace(Replace((DT_WSTR,50)(getdate()),"-","")," ","_"),":",""),".","_")+".xls"

But [Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: The filename, directory name, or volume label...