I am trying to import a tab-delimited text file using SSIS and it is choking on all the numeric fields because they numbers have comma-separators (e.g. 1,000.54). I keep getting t …

I need to output the results of a query to a CSV file then send to somebody on email. I would like to schedule this automatically on a SQL Server so is it possible to create tha CS …

While deploying the SSIS package on the server I am getting the following error TITLE: Package Installation Wizard Could not save the package "C:\BI Microsoft\Samples\SSIS\MySamp …

Let me start with the background. The number of days that we want to go back comes in from a table. Select column1 from table1 This gives an int value of 2. This could change …

I have some data in following structure.I want to split the data such a way where ac_no wise database will create & part_no wise table will be created on respective ac_no. …

Hello, I'm trying to figure out a solution on this as a proof of concept. I have a table called "test_table_with_errors" with 4 entries, 3 of which have invalid dates as nvarchars …

Hi Team, Not able to start log backup plan through job. It is showing in suspended mode. SSIS services found stopped while starting the same it is giving following error. SQL S …

I am creating an ssis package that copies and renames a file each time the package is run. I can get the filename to include the current date, however I would also like to include …

I have an SSIS package where I have a Data Flow that reads an Excel spreadsheet that goes through a data conversion to get the data from NVARCHAR to VARCHAR and then puts it into a …

I am writing an SSIS 2005 package that reads a spreadsheet and does some ETL on it. The L: drive on my workstation is mapped to a network drive. When I browse to that on the Excel …

my package consists of EXECUTE SQL TASK that executes a sql stored procedure and there is a local variable in the stored procedure. I have a Data flow task. I want to execute the d …

I am trying to find any info on using the SAS 9.1 OLE DB data connection in SSIS. I am not finding any documentation on this thing. Has anyone ever used it and if so can you plea …

I am facing connection problem when creating a connection in SSIS package. What I did is, created a Dataflow task and in Data Flow Task, I dragged "OLE DB Source" as source for SSI …

Hi, I am new to SQL Server Integration Services and am building an ETL pipeline to transfer data from an Oracle DB to a MSSQL Server database. Can you please tell me how I can co …

Hi, i have 2 data sources (i.e. 2 different tables) that i need to join and dumps the output to a destination table. table a consists of 5 records while table b consists of 5000 …