SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
0
votes
0answers
16 views
Connecting to Oracle from SSIS using ODBC
I am using SSIS to pull data from Oracle DataSource. In the Connection when I chose the Oracle provider and gave the necessary inputs I got error saying "Oracle client and networking components were ...
2
votes
3answers
32 views
SSIS Rollback Package
I have several data flow tasks in my package that depend on other data flow tasks. For testing reasons I want to run the entire package and then roll it back after it completes. How do I do it?
1
vote
1answer
64 views
How to avoid empty rows in SSIS Excel Destination?
Does anyone have a way to avoid empty rows when using SSIS to export to Excel. Here's a simple example of one data flow task:
OLE DB Source:
Data Conversion (to handle the annoying UNICODE / ...
0
votes
2answers
36 views
'skip rows' in a flat file source does not work as advertised
In SSIS(2012 specifically) there is an option in the Flat File Datasource to skip a number of lines at the beginning of a file. The preview appears correctly. However, when trying to execute the data ...
1
vote
0answers
36 views
Accessing environment variables at design time in SSDT?
I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me.
The result that I am trying to achieve is that the user context's temp folder(stored ...
2
votes
1answer
305 views
Is there a way to do data export from Amazon Web Services RDS for SQL Server to On-Premises SQL Server?
We have a large Amazon Web Services RDS for SQL Server instance and we would like to do incremental data transfers from RDS to On-Premesis SQL Server on a regular basis.
The On-prem server will be ...
2
votes
1answer
105 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
31 views
VLDB with large quantity of data file imports
I am a little out of my league with this scenario and hope this community can help get me on the right direction.
I have recently been tasked with re-designing and implementing a database application ...
12
votes
1answer
229 views
“Access is denied” when connecting SSMS to Integration Services
I receive the following error when attempting to connect SSMS to Integration Services using a particular SQL Server cluster's network name:
Connecting to Integration Services service on the ...
4
votes
2answers
103 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 ...
2
votes
2answers
79 views
How can I dynamically back up all SSAS databases on a given instance?
I want to dynamically back up all the databases on a given SSAS instance using a SQL Agent job (which would most likely involve executing an SSIS package). It is imperative that this is a dynamic ...
2
votes
1answer
55 views
SSIS - How do I execute a single OLE DB Command for mutiple paths?
I have an SSIS package (2008 R2) that I'm working on and I find myself duplicating the same OLE DB commands repeatedly and whenever there is a change its a nightmare to go back through and update all ...
1
vote
1answer
63 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 ...
0
votes
2answers
81 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
1answer
250 views
SSIS How can I write to a Specific Cell in an Excel Sheet
I am trying to complete what I thought would be a very simple task but after hours of looking thru various articles and attempting different methods, I still have not been able to Write to a specific ...
0
votes
1answer
49 views
SSIS Adding column to excel sheet template destination when importing from SQL Table Source
I have an excel sheet template that has 3 columns. I also have a SQL server table that has the same 3 columns plus an additional 4th column. I need to import all 4 columns from the SQL table into the ...
0
votes
2answers
3k views
how to send mail from gmail smtp server by using the ssis [duplicate]
I'm just getting into sql-server SSIS, so forgive me if this is a basic question. Use the SSISwant to send mail from gmail smtp server.
Smtp host =smtp.gmail.com
port=587 ,
...
0
votes
1answer
158 views
How to load more than one MS-Access-db tables with data in SQL-Server-DB
I'm just getting into SQL-server 2008 R2 ssis, so forgive me if this is a basic question. I'm building an application using integration service.
One of my computer folders contains more than one ...
3
votes
2answers
250 views
Error trying to run SSIS Packages in SQL Server 2008 SQL Server Agent
I am trying to run a number of SQL Server 2008 stored procedures that are wrapped in SSIS packages consisting mainly of Execute SQL Tasks. They run fine in Visual Studio 2008 after deploying to a ...
0
votes
2answers
205 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 ...
1
vote
2answers
584 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 ...
1
vote
2answers
118 views
How do I run a SQL Server 2005 job on Windows 7?
I have Windows 7 and SQL Server 2005 Version 9.00.1399.
I can successfully create an SSIS Package, however I am unable to execute it successfully as a scheduled job. When I run the job, SQL Agent ...
3
votes
1answer
50 views
Stopping SQL Server Agent: Effect on runnings jobs
On a server with MS SQL Server 2008 installed, we use the SQL Server Agent to schedule a large amount of SSIS-packages, all with unique schedules throughout the day.
Now and then, the server needs to ...
2
votes
1answer
253 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 ...
2
votes
1answer
63 views
Backup on an empty SSAS database hangs
I created an SSIS package to iterate through all databases on an SSAS instance. It grabs the DatabaseId using AMO in a vbscript, then generates the XMLA to backup each database.
Most databases ...
0
votes
3answers
95 views
SQL agent job step's connection managers
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
0
votes
1answer
512 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
35 views
XML data source with XSD validation importing the same data despite different files
Please bear with me, I've never used XML as a data source, nor am I familiar with XML itself, so I'm not entirely familiar with the nomenclature.
I have a series of XML files with data to be imported ...
4
votes
1answer
72 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 ...
0
votes
2answers
114 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 ...
3
votes
3answers
150 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
52 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
60 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
79 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
121 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 ...
5
votes
2answers
253 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 ...
2
votes
0answers
133 views
Microsoft Visual Studio is Busy
I am working in Visual Studio 2008 on a SSIS package. It is really frustrating that I get "Microsoft Visual Studio is Busy" message quite often. It almost happens every time I try to open a data ...
1
vote
1answer
151 views
error in Execute SQL Task with parameter
I have an Execute SQL Task object in the Error handlers section of a SSIS package. What it does is inserting a record to a table using OLE DB connection. There is a value in the insert statement that ...
1
vote
0answers
237 views
Login failure when running a SSIS package from a SQL Server job
I have a SSIS package that migrates data from a Sybase database to SQL Server. The connection to the source database has been made through an ODBC connection.
If I run the package directly on my ...
1
vote
2answers
123 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
43 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
0answers
59 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 ...
1
vote
1answer
100 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
629 views
SSIS Row Count: Getting a null variable error where there is clearly a selected variable
Validation error. Build Files Count VIE [245]: The variable "(null)" specified by VariableName property is not a valid variable. Need a valid variable name to write to.
From what I can tell, this ...
3
votes
2answers
61 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
160 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
75 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
68 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 ...
1
vote
2answers
226 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())
...
6
votes
1answer
534 views
Timeout expired error while using copy database wizard
Microsoft made me believe that SQL Server 2012 Copy Database Wizard is the most optimal way of copying a SQL Server 2000 database to SQL Server 2012. After struggling a few hours, I was able to get ...
