Have you tried with a SQL OLEDB connection?

subhaannai (2/17/2012)

---

im using script component in my data Flow.

For Example :

If my data soruce returns 10,000 records,

inside my script component im creating a...

subhaannai (2/17/2012)

---

Hi,

Thanks for your reply.Actually Inside my Script component ,i am creating a file and writing some data's into the file and in the mean time i have to update...

The...

This is not quite correct. Eugene...

You should not expect the STR() function to throw any light on this...

rajendra prasad-377679 (2/16/2012)

---

hi brother this is very very simple , for to do this u have to do little bit work in Excel.. just follow my steps..

1.copy the content in...

Koen Verbeeck (2/16/2012)

---

Phil Parkin (2/15/2012)

---

A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I...

herladygeekedness (2/15/2012)

---

Configuration, I don't know, that would be custom to your...

Yes - nothing special is required - on an instance of SQL Server, you can access functions in a database from any other database (subject to access rights), using suitably...

devin.sills (2/14/2012)

---

Elliot --- thanks for your reply. The problem is that once the variable is added, it cannot be changed at run time b/c the new behavior is such that...

Just been playing with this and I think that Eugene's solution may have a slight flaw. SET NOEXEC OFF needs to be executed between creates to ensure that the subsequent...

That's ugly, but also taught me something, thanks! 🙂

scottichrosaviakosmos (2/14/2012)

---

Actually I am doing this in a script and i am doing this for 50 procedures and each procedure is more then 50 lines. So, dynamic query will not...

Ignore this - Adi has already spotted the issue.