MostInterestingMan (8/10/2010)

---

Hello,

I have a date column with data type DT_DBTIMESTAMP that I am exporting to .csv. In the Flat Connection Manager the data type is correct and I can see...

sree-879715 (8/10/2010)

---

Hi,

Is there a way to create a package on the server where I have SSIS installed and export it to another server where we dont have SSIS and schedule...

stricknyn (8/10/2010)

---

Hi All,

I have a script component which contains a function that will be used by many script components in my package. I was just looking for some pointers...

We can't avoid...

I have tried a stacked bar chart in SSRS, and can almost get what I need, although the axis cannot be labelled with times, only with duration. I have also...

No problem. You are welcome.

Yes. I didnot notice that. Is there a need of storing...

Can you try this?

exec ('Select sqlcmdline from #sqlcmd') ?

Other option is to declare the variable as type "Object".

Then you have convert it back to string and store that in a string variable in an activex script like below..

...

Jpotucek (8/6/2010)

---

The Server I am migrating the packages FROM and the Server that the packages are going TO are on two different and seperate Networks at two different hosting facilities....

I have a sql server 2005 on a 32 bit platform and we run about 20 DTS packages in backward compatibility mode.. in other words, the DTS packages show up...

Janie.Carlisle (8/6/2010)

---

Sounds like an interesting option although I am not sure how to do it. What is happening now is the package is going into SAP and extracting data from...

SwedishOrr (8/5/2010)

---

The reference material I'm looking at is under the C# example space at http://technet.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.application.savetodtsserver.aspx. Specifically, the line I'm curious about is "app.SaveToDtsServer(p, null, @"File System\myFolder2", "yourserver");"

What is "File...

Janie.Carlisle (8/5/2010)

---

I inherited a package that generally runs well and gets the job done. However, occasionally when doing a date conversion from SAP date to SQL datetime, it encounters a...

geilecj (8/5/2010)

---

So, I assume a for-each loop will be needed for each filetype...

I have done it this way before but just becomes a PAIN when you have 15 for loops...