Check your variable declaration by right-clicking in your control flow pane and choosing Variables. Make sure that you have set your SSIS variable to be of type "String". ...

Again, how is it that you determine that there is a problem? Does your package fail or are you getting incorrect output?

You might also post some of your script...

Just a quick FYI on copying... I have...

sudheer_1185 (11/26/2008)

---

Hi

I am assigning value to global variable using script task

Dts.Variables("gvRunDt").Value = RunDt

Here "gvRunDt" is global variable to which i want to assign a value at run time .The...

Problem resolved - It was the firewall (Symantec Internet Security) after all. It actually kept the host machine from connecting with the VM and vice versa since I'm using...

You could use a script task to create your filename as a variable based on the date.

hth,

Tim

Are you using a different destination (e.g., a different folder) for each file? If not, you should be all set. If you want to write each file to...

Definitely a problem with big companies and multiple layers of budgeting. It's all about profit, so if a unit/department/division proves that they can get by on 75% of what...

That's where I was leaning, but the odd thing is that I can connect to my other PC from to and from the laptop host as well as to/from the...

Good article, Brandie. I appreciated the steps to create the MSI file - I've written a lot of SMO but have never taken the time to create the MSI....

Will do Brandie, if you promise to check out my videos on JumpStartTV 🙂

Steve, I'd like a copy of V4 if you can get one. That was the first publication containing anything I had written. Aahhh, memories.

There are some limited capabilities in SMO to actually move data around, but in my opinion trying to do this is like using the heel of your shoe to hammer...

Yep - check out the Trash Destination (http://www.sqlis.com/post/Trash-Destination-Adapter.aspx). I've been using this thing for years. You wouldn't think such a thing would be useful, but I've included it...

Shark Energy (11/21/2008)

---

Hi all,

Have a package where I move data in from a csv, run it through various lookups, and then create an "Items" record in my db. But for...