![]() It is also possible to save these packages and have SQL Server run them as tasks. All of these deficiencies can be overcome by using SSIS packages to design and automate import tasks. This can be offset by the second option of using the import tool however, the import tool can not do custom conversions of data types. With the first option you would have to write all conversion code and set up code to do field mappings in TSQL, if you are not comfortable with SQL then this will be a challenging task. ![]()
0 Comments
Leave a Reply. |