SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
3
votes
1answer
44 views
Convert SQL Server 2012 SSIS package to 2008
I've created a few SSIS packages in SQL Server 2012 that I need to run on SQL Server 2008. I've been told that it is impossible in their current state.
Is there a way to convert the 2012 packages to ...
3
votes
3answers
91 views
Fixed length text file insert into SQL table
I am not a DBA on this one and I will not have access to BCP or anything like that. So I'm wondering if there is still a way to do it in SQL keeping it very basic.
I have 100's of text files that ...
0
votes
0answers
51 views
Transfer tables from multiple servers into one single server [duplicate]
I have to migrate similar tables present in multiple different servers (30+) into our new server using SSIS package. What would be the right approach towards this?
I was successfully able to transfer ...
3
votes
1answer
49 views
What is the safest way to run SSIS on Multiple Named SQL Server Instances?
I have an Active/Active SQL Server 2008 R2 cluster. There are two named instances on each node and no default instance.
I need to deploy SSIS packages to the different instances. To do this, I ...
0
votes
1answer
40 views
SSIS convert DT_WSTR to date
I'm new to SSIS trying to covert data types. I'm pulling data from Google Analytics and loading data into a SQL 2008 database. The date column from Google analytics appears as "DT_WSTR" and the values ...
1
vote
2answers
58 views
Converting Non Unicode string to Unicode string SSIS
I am creating a package where I will be exporting data from a database into an empty excel file. When I added only the source and destination components and I ran the package I got a conversion error ...
0
votes
2answers
81 views
Sync Indexes between two tables
I need to automate and Sync only indexes between two tables ( Primary and Stage_Table) within the same database.
I tried using SSIS SQL Server Objects Task, but looks like it works only when we sync ...
0
votes
2answers
51 views
Copy data through SSIS package from one machine to another
I have data in few excel sheets which are to be loaded into tables. I've created a few SSIS packages to do this on my local machine.
Now I have to move these tables onto my client's machine, which is ...
1
vote
2answers
76 views
Will SSIS 2012 work with SQL Server 2008R2 (not integrated)
Our company has SQL Server 2008R2 and plans to upgrade to 2012 in late 2013 or early 2014. I would like to use SSIS 2012 now as we do have the software.
We have a company policy where we cannot run ...
1
vote
1answer
36 views
SSIS Suddenly Requires DCOM Permissions
I have recently deployed some SSIS packages. I made a job to run them one after another. However, I am now allowed to use MSDTC. So I chained the jobs together like I have done before, but now I am ...
0
votes
1answer
182 views
How to override SSIS 2008 package config file path?
I have an SSIS 2008 package with a single configuration named Config. I would like to use the dtexec /SET switch to change the path of the config file that it uses so our developers that build the ...
0
votes
0answers
49 views
SSIS Data Flow Task Slows Down
I am trying to transfer data from one table to another in the same database using SSIS. It seems to go fine (I can see the record count going up) until it gets to about 30 million records, then it ...
3
votes
2answers
56 views
Executing Child packages without using master package
I have many Fact and Dimension packages which are executed using vb script . Today one of my seniors proposed that these packages should be executed individually instead of creating a master package ...
1
vote
0answers
108 views
SSIS Merge Join Trouble: 3 tables into 1
So I am having trouble merging three tables into one. All sources are DB, and I am using the MERGE JOIN function. When I join my first two tables, using standard left inner join, it returns the exact ...
1
vote
0answers
60 views
Login failed for user sa ssis 2008
I have a problem with ssis2008
I built a package that have a connection with SQL Server authentication (username : sa).
When I use BI, it works fine but when I build a job that used this package it ...
5
votes
2answers
62 views
Turning on TF610 in SSIS
I have a simple SSIS package that loads a dummy file that contains 100000 rows. Each row is around 4k long, one int column and one long text column. I'm trying to test TF610 when loading this data ...
5
votes
2answers
201 views
SSIS keeps force changing excel source string to float
There is a column in Excel that is supposed to be text, but SSIS sees numeric text there and automatically makes it double-precision float [DT_R8].
I can change it manually in the Output branch's ...
0
votes
1answer
103 views
SSIS Raw Data Import Into SQL Server 2008 R2 - Truncation and Condensed Data Type
[Intro]
I have written a two pack SSIS solution to perform a scheduled hourly update of data from multiple tables in a single db (SRC) to single table on another db (TRG).
I get the following errors ...
2
votes
2answers
192 views
SSIS Data Flow Task Excel to SQL table NULL value will not work for small INT datatype
I have a package that imports excel data into a SQL table. One of the columns in the table is of "smallint" data type and it allows for nulls. The excel file column that has the data that is suppose ...
3
votes
1answer
143 views
SSIS Design consideration with object variables
I have an SSIS package for SQL Server 2008 R2. In the package I am required to work with an Access database (one to many) and iterate through it running validation checks with the data. The validation ...
1
vote
2answers
149 views
SSIS Expressions Date Format get just YY for year
I found many articles on date formatting expressions in SSIS but I couldn't find one that specified how to get just the Year such as 13 for 2013 or 12 for 2012... I tried
DATAPART("yy",GETDATE())
...
-1
votes
1answer
113 views
SSIS SQL Result to tab delimited txt file [closed]
I have created a package that Runs a Sql Query and then puts the results into a flat tab delimited txt file.
When I opened the flat file in excel everything was in the right columns but in columns ...
1
vote
1answer
42 views
SQL Server 2012 catalog.executions to sysjobhistory - any way to join them?
I have exhausted my resources and can't find a foolproof way to join the ssisdb.catalog tables to the jobs that run them. Trying to write some custom sprocs to monitor my execution times and rows ...
1
vote
2answers
118 views
SSIS Visual Studio 2008 reference variable scope in expression builder
When creating an SSIS package in Visual Studio 2008, in the expression builder, I know I can reference a variable by using @[User::FilePath] for example but this only works if you are evaluating the ...
3
votes
2answers
142 views
Relating ExecutionInstanceGUID to the SSISDB
The 2012 release of SQL Server Integration Services, SSIS, has delivered an SSISDB catalog which tracks the operations of packages (among other things). The default package execution for solutions ...
5
votes
1answer
282 views
SSIS File System Task Copy File Could not find part of the path error
I have created an SSIS package that uses a File Systen Task (copy) that copies a file from 1 folder to another. The package runs fine when I run it from my local computer but when I import the package ...
2
votes
1answer
186 views
SSIS Package Data Flow Task RollBack on Error
I tried running a package and it failed but I noticed in the output box (in visual studio) that it managed to write 2000+ rows to a table. I was wondering if an SSIS package would roll back the ...
0
votes
0answers
35 views
How to Copy Yes/No field data in Sharepoint list to Sharepoint list using SSIS Package?
I am copying sharepoint list data using SSIS package and they are copying perfectly. But the problem is when there is a Choice field or Yes/No field at that time it is copying only default value to ...
0
votes
0answers
47 views
Errors loading one set of data from Staging to Data Mart Fact Table
I am very new to SSSIS and am trying to load sales data from 3 sources. I have created data flows to extract the source data into staging, all of these work OK with no error. I now want to load ...
1
vote
1answer
85 views
Inserting a new lookup value for the SSIS Lookup Transformation
This may be obvious, but I've been banging my head for a while... please point me in the direction of an article if there is one.
I'm importing a series of Excel files into a SQL database.
They will ...
3
votes
0answers
145 views
SSIS Recordset Destination error
I have an SSIS package targeted at SQL Server 2012.
I have it deployed into the Stored Packages in Integration Services and then have a SQL Server Agent job which executes it.
The first part of the ...
4
votes
1answer
73 views
In SSIS 2012, what is the purpose of flagging a package as an “Entry Point” package
In the Visual Studio designer you can right click on a SSIS package and designate it as an "Entry Point" package"
Doing a search I found this page on MSDN which states:
The value of 1 signifies ...
0
votes
1answer
27 views
Concurreny update error when using SSIS
I am encountering concurrent update error when using OLE DB command to execute a update procedure in SSIS.
Below is the segment of code which will check for concurrency update. Currently I removed ...
0
votes
2answers
239 views
Advice for ETL from Oracle to SQL Server?
I'm building a data mart in SQL Server which needs to extract each month from an Oracle database. Currently this is done by exporting to flat files, then running all the inserts/updates in SQL ...
2
votes
1answer
208 views
SSIS 2008 Package Configurations being ignored
With the change to package configurations in 2008 compared to 2005 when I specify /ConfigFile something.dtsConfig on the command line, variables defined in the package are keeping their design-time ...
1
vote
2answers
83 views
Pull Access schema into a SQL Server table
We had an assembly that used to pull a list of tables and their columns from an Access database and place the listing into a SQL Server table for later use. For various reasons the assembly is no ...
2
votes
0answers
41 views
Limit Output Flat File Size In SSIS
I am using Flat File Destination to export my data's to a Text file. I need to limit the output File size to 1 MB. Is it possible?
1
vote
2answers
453 views
How to import table's data in MySql from Sql Server?
I am trying to export table from SQL Server 2008 R2 TO MySql 5.5. For this I am using SQL Server Import and Export Wizard of Sql Server 2008, but it is giving this error.
Here this error may be ...
0
votes
0answers
20 views
Twice job results in sql server, last one is left in progress [duplicate]
I have the job MP - Create CSV which execute a package SSIS in sql server 2008, when I check for the job history I see the result at step 0, I expand and I have 2 results for the step 1.
Fist result ...
2
votes
1answer
80 views
Twice job results in sql server, last one is left in progress
I have the job MP - Create CSV which execute a package SSIS in sql server 2008, when I check for the job history I see the result at step 0, I expand and I have 2 results for the step 1.
Fist result ...
1
vote
1answer
57 views
SQL Data Collector - SSIS required on source server?
For SQL Data Collector:
Do you need SSIS (SQL Server Integration Services) installed on the server that you are collecting data from. Or can the packages be run from another server -- like the one ...
6
votes
2answers
151 views
SSIS Validation slow. OLTP OLAP running on same server
I have four identical servers 2 are used in production and the other two are demo machines/emergency fail over boxes. The more powerful machine a 16 core 127 gigs of Ram hosts both our Datawarehouse ...
0
votes
1answer
128 views
Convert rows to columns in SSIS. Unpivot?
If I have data like this
"","",WAREHOUSE ID,1,2,3,4,5...
"","",WAREHOUSE CODE,BOS,HOU,LAX,NYC,CHI...
"","",WAREHOUSE NAME,BOSTON,HOUSTON,LOS ANGELES,NEW YORK CITY,CHICAGO...
But want to transform ...
2
votes
1answer
117 views
How can I make sure the SQL Server query optimizer uses the exact tables in the query
I have a query running in SQL Server 2008:
select count(*)
from table1 join
table2 on table1.col1 = table2.col2
In the data warehouse where this script runs, a table called thin_table1 is ...
3
votes
1answer
54 views
Integration Services Catalogs - Version Description
In Integration Services Catalogs I can see what versions of a package/project are available and if necessary revert to an older version. On this dialog I see a field "description" however I found no ...
0
votes
1answer
176 views
Import batches of rows from Excel in parallel
We receive an Excel file weekly currently containing about 250k rows. The file grows by about 300 rows each week.
In SSIS I've hooked up an Excel source to an OLE DB destination to import the file ...
2
votes
0answers
311 views
Importing Excel files with SSIS
I'm trying to import an Excel spreadsheet into SQL Server 2012 using SSIS. There is only one sheet in the file. The file is a SalesForce export. I believe the Sheet name changes depending on when the ...
3
votes
1answer
411 views
SSIS package with BULK data load
I analyzed a C# program over the weekend for a customer that basically does the following:
Truncate Table
Fetch Data (source on these is either remote database or local database where job runs)
...
1
vote
0answers
196 views
sql agent job hangs without any errors or warnings
Problem:
we have a SQL Agent job which runs everyday in the morning at 4:00 am. This job hangs sometimes without providing any errors or warnings. It just hangs. BUT when i stop the job and run again ...
1
vote
1answer
155 views
How to avoid log space error while executing SSIS packages?
I'm executing ssis package with more than 70 million data's. But I'm facing issue as
log space full error message while executing the package.
Is there any option to resolve this issue?
