sam.dahl (3/1/2011)

---

In this case trimming some char values, for insertion into varchars at the destination, caused some leading spaces in the second part of a composite primary key to be...

sam.dahl (3/1/2011)

---

I'm setting ValidateExternalMetadata to false based on advice from relevant articles. I can't for the life of me find the ones I was looking at 4 weeks ago, but...

But ... you are possibly insane 😉

In the LoadFromSQLServer method, you don't specify values for the username and password.

Which means that you are using Windows Authentication. Can your ASP.NET application log in with windows authentication and...

nahk.fussuy (3/1/2011)

---

I'd get on to the numptie that decided to put three types of data in a random fashion into a flat file.. give em a quick kick and get...

I'm going to use that one in my next...

Jeff Moden (3/1/2011)

---

Heh... thanks for the feedback, Koen. I may just have to teach myself C# so I can write a conditional splitter that would make it all a...

GSquared (3/1/2011)

---

Koen Verbeeck (2/28/2011)

---

TravisDBA (2/28/2011)

---

Any question in an interview where your first gut feeling is "That is none of your business." Go with your gut, that is not a good...

I know. 😎

😀

Jeff Moden (3/1/2011)

---

I'm just ticked at the lack of programming in SSIS and I'm amazed...

SKYBVI (3/1/2011)

---

Koen Verbeeck (3/1/2011)

---

Where do you think they use checkboxes for?

If it was only one correct answer, it would have...

Where do you think they use checkboxes for?

If it was only one correct answer, it would have been radio buttons.

This article gives a good overview:

http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx

and so does this one:

http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

I personally use the OLE DB connection manager, where parameters are replaced with a question mark. Important is that the ordinal...

reem_kn (3/1/2011)

---

Thank u

I tried it but not work

I'll told u what I want

I call Package in c# code then execute this package

and in db in integration services in msdb...

First of all, this is an SSIS Script Task, not an Execute SQL Task.

Regarding your error, you cannot reference SSIS variables like that.

You need to use Dts.Variables("Code").Value to get the...

Are there any errors or warnings?