Do the following roles have execute permission on that stored procedure:

db_ssisadmin, db_ssisoperator, db_ssisltduser

You can transform the data types directly at the source by writing a proper SQL statement, or you can convert them using the data conversion component.

Regarding your 2nd question: I...

Are you 100% sure that all the configurations come through correctly when executed from SQL Server Agent?

Maybe you can quickly add a task in the package that writes all the...

If...

I'm certainly not an Oracle expert, but I have found the following topic:

http://forums.oracle.com/forums/thread.jspa?threadID=327112

Maybe the last reply can be useful?

I think the easiest way to do this is to perform some sort of check (either with the execute SQL task or with a script task that validates the connection,...

Tony++ (11/16/2010)

---

I've found this useful in the SQL behind an SSRS report. The report parameters lets the user choose the sort, the report passes this into the SQL, and...

I found this quite an excellent question. Sure, there was some trickery involved by switching string1 and string2 and by showing an example that works, but hey, you can't make...

pravasis (11/16/2010)

---

Well, it depends on the number of CPUs you are having. In Figure 6 of "Design approaches" section, you will find two additional union all which are redundant. This...

Thanks for the very interesting article.

But I have trouble finding the section that...

Can every column contain it's maximum size? There's no chance in shrinking the size?

If not, just don't use blocking components 🙂

I hear that from time to time 😀

(just kidding of course)

Glad that it worked out.

Integration Services:

Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)

It's quite a large book, but the first chapters provide a really good overview of SSIS. Case studies are...

bharadwaj.manchu (11/15/2010)

---

Thanks da-zero.

I didnt understand that how can we clean data using a derived column task.

also If possible suggest me an approach on how to cleanse data in an SQL...

Sure you can use a union all.

ProductID and VendorID are probably both integers.

ProductName and VendorName are probably both strings.

You can place NULL in the third column of the first resultset...