Questions tagged [ssis-2014]

SSIS 2014 is Microsoft SQL Server Integration Services 2014, and is part of SQL Server 2014. SSIS allows SQL Server to interact with other technologies, including import and export of data to and from other formats, or ETL, and data warehousing. Please add the SSIS tag.

Filter by
Sorted by
Tagged with
2
votes
1answer
4k views

CAST SUBSTRING to NUMERIC SSIS

I have a fixed width text file that I am bringing in through SSIS. As part of the input into SQL Server I am grabbing a string of characters and trying to CAST them as numeric in a derived column. The ...
4
votes
1answer
1k views

Apply settings to multiple output columns in SSIS flat file source

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to ...