No You can't use the dynamic sql in the functions

Thanks to Jeff and eralper on your valuable Inputs.

Nice Question, i got it right because recently i faced this kind of situation in one of my package.

i am looking forward to here more on "Mastering SSIS".

Eralper (11/21/2010)

---

If you have foreign keys, constraints etc it will take a longer time to delete records from sql table.

Also it will be better I guess to disable indexes (delete...

For analsyis it is alwasy better to have the OLAP (DW) database where you will have your fact tables and dimension tables. From this database you will need to create...

My Vote is For C# as it is much eaiser and suppots fully OOP Concepts and close to any other OOP Language.

i don't think it is possible to get the name of the Container in the script task. Why don't you put the name in the variable it self and then...

Ya that's what the above solution gives.

In your dataflow task's oledb source select the data access mode as sql comman and

add the sql Command text and where ever you...

Nice Question.Generally we will prefer to create the table first and then try to insert into it in these case.

No, the second filer is...

The One Approach that i know is to dump the csv file into the temp table and then use the execute sql task, where you can write a Query to...

SELECT [Month] = DATENAME(mm,SomeDateTime),Year(Somedatetime),

Amount = SUM(SomeAmount)

FROM #MyHead

GROUP BY DATENAME(mm,SomeDateTime),Year(Somedatetime)

ORDER BY CAST(DATENAME(mm,SomeDateTime) + '...

I Think it is your Sql server Management studio setting problem

in SSMS just go to

Tools --> Options --> Query Results --> Results to Grid --> Max characters Retrieved...

By the way your Print Function has limitation to Print the charecters i guess it is 8000

Hey you can use

varchar(max) or nvarchar(max)

Please avoid using text and ntext as these will not be available in the latest versions of the sql server

Can refer :

http://msdn.microsoft.com/en-us/library/ms176089.aspx