![]() I suggest you use the Object Model API which allows you to develop SSIS packages programmatically. ![]() Using sw as new Io.StreamWriter(strFile,False) StrContent = strContent.Replace("DTS:MaximumWidth=""50""","DTS:MaximumWidth=""500""") dtsx file using Regular expressions)įunction To Read and Replace content of dtsx file (Vb.Net) Public Sub FixDTSX(byval strFile as string) (you can read my answer Automate Version number Retrieval from. dtsx files in a folder and replace DTS:MaximumWidth="50" with DTS:MaximumWidth="500" using normal String.Replace function or using Regular expressions. You can create a Small application that loop over. You can use BIML (Business Intelligence Markup Language) to create ssis package, if you're new to BIML you can access to BIML Script website for detailed tutorials. ![]() Easiest solution, In the Flat file connection manager - Advanced Tab, select all columns (using Ctrl key) and change the data length property for them all in one edit.I don't think that there is a way to achieve this from SQL Server Data Tools.īut you can do some workaround to achieve this:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |