I think you can simply store the package in msdb and every time you require to use that template you can import package in BIDS, make changes to it and...

You can use the flat file source and configure your path to get access to the files.

I would say just change the script that generates the source file to keep the column names in the header row. I am sure it is very simple to do...

Hi,

It seems to be a right idea but I am not realy sure how would I concatenate the error message using the script or sqltask ? It will be...

Hi,

It seems to be a right idea but I am not realy sure how would I concatenate the error message using the script or sqltask ? It will be...

Just follow the steps.

http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

Let me answer my own question here :).

One way of dealing with longer strings is to change the data type to DT_TEXT or DT_NTEXT in advance tab of source file...

Sorry Steve I guess you mixed up both question. I found a way to deal with my previous problem but now i am facing realy wierd issue.

In this case the...

Thanks Rocky. SUBSTRING does the same, its just more efficient way coz you can set the start point and length. I figured out that my problem is to get the...

LTRIM([sAMAccountName], 100) is not right syntax. I guess the right right syntax would be LTRIM([sAMAccountName]), which will remove all the spaces.

e.g String " Hello" would be returned as...

does it not just remove the spaces? according to the syntax i looked at

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

LTRIM works only with the DT_WSTR data type. A character_expression argument that is a string...

hi Will,

I tried using the expression,

(DT_STR, 100, 1252)SUBSTRING([sAMAccountName], 1, 100)

But it doesn't work. I am not familiar with the SSIS functions but the resultant string in this case is...

I have tried both the data types available under the data conversion transformation i.e, DT_numeric and integer but none of them worked. However i figured out that using,

LEN(TRIM(column_name)) >...

ryes data conversion transformation works most of the time. But in some cases it gives you the error message related to the potential data loss. I think the best way...