Questions tagged [ssis]
SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server
80
questions
2
votes
1
answer
190
views
SQL server Intergration services 2008 sub queries
I am looking for a way to execute sub queries from within a main query that I execute in my SSIS package.
So When I execute the package, I want to be able to execute the sub query after everyline ...
0
votes
1
answer
52
views
SSIS Bug - Flow Components going blank
Every time I change tabs in SSIS or minimize/maximize the program, every node loses everything but its text, making it very hard to follow the diagrams. The image/border/etc. returns when I click on ...
1
vote
2
answers
536
views
Can SSIS transfer data from a SQL Server 2005 database to a 2008 database?
I need to transfer data on a regular automated basis from a database running on a SQL Server 2005 instance to a remote database running on a SQL Server 2008 instance. I'm new to database ...
0
votes
3
answers
756
views
BIDS and SSIS projects on SQL Server 2005
I have trouble just getting started with BIDS, the development environment for creating SSIS packages in SQL Server 2005. I don't know if it is just a license / version issue or if i am missing some ...
0
votes
1
answer
3k
views
Access SSIS Projects Stored in MSDB Database in BIDS?
I have a database server (db1) that has SSIS installed and configured (SQL 2008). I have configured it so I can remotely connect to SSIS through SSMS. Now I am trying to open one of these SSIS ...
2
votes
3
answers
2k
views
Problem transferring file to FTP server - 503 Could not create file
I try to transfer a file from SSIS package to a FTP server provided by my client. When I try connecting and transfer using a FTP tool (WinSCP) manually it works fine and file was transferred. But when ...
0
votes
1
answer
177
views
MS SQL dts to ssis migration error
I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on 9.0....
0
votes
1
answer
779
views
SQL Server Agent 2005 job runs but provides no output
Essentially I have a job which runs in BIDS and as as a stand lone package and while it runs under the SQL Server Agent it doesn't complete properly (no error messages though).
The job steps are:
1) ...
0
votes
2
answers
3k
views
SQL Server 2005 Agent running SSIS job can't find file path
Basically I'm trying to run a functioning SSIS job (created in BIDS) under the SQL Server Agent - it reads a set of Excel spreadsheets and dumps the results into a table.
The problem I'm having is ...
0
votes
1
answer
1k
views
SSIS Foreach loop (SQL Server 2005) adding loop variable causes failure
I'm trying to use SSIS to traverse a directory of Excel files and put them into a table in SQL Server.
I seem to have a basic choice - either I get the same spreadsheet dumped in the table 10 times ...
3
votes
2
answers
9k
views
SSIS: How to create and export data to Microsoft Access 2003 database?
Goals
- Automate exporting SQL Server 2005 views to Microsoft Access 2003 database (no transformation required) through SQL Server Job (with SSIS package)
There is no "Access DB Destination" in BI ...
0
votes
1
answer
233
views
How to remove database backups 2 days or older through SQL Server 2005 Integration Service?
I have a simple Integration Service package which has one SQL Task as shown below;
WLSTAGE Bakup using Red Gate: Calls master..sqlbackup to backup database
Here is the SQL to run the actual backup
...
0
votes
1
answer
3k
views
SQL Server; how to import data from another DB with different collation; conversion errors?
I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (right click DB > Tasks > Import Data)
DB1 is the source DB, it has a collation set to ...
5
votes
2
answers
20k
views
Can I tell the last modified date on an SSIS package from Integration Services
Using SQL Server 2005 (and 2008)
With a DTS package, I can open it, and it lists the date that the package was last modified. I have some SSIS packages, and I need to know if they have been modified ...
1
vote
2
answers
379
views
SQL Server 2008 SSIS package compatability
I am trying to save an SSIS package on a sql server running 2005. The issue I have is that I am using SQL Server Management Studio 2008 on my local machine to do this and it won't let me save the ...
1
vote
1
answer
39
views
Server Side Includes for certain files
at the moment, all of my .shtml files are being parsed by SSI. Some of these pages do not have SSI and it would be more efficient if they did not have to go through SSI. Is there anyway to specify a ...
4
votes
2
answers
8k
views
How can I Import Data using SQL Servers SSIS, when using foreign key constraints?
I'm trying to set up an import form live database to our development database.
I trying to do this using SSIS, but the import is failing because of constraints.
E.g. I have the following tables:
...
0
votes
1
answer
404
views
Connect to SSIS from within Management Studio
A newbee question: Connect to SSIS from within Management Studio?
I have a running service named: Integration Services 10.0, but from within Management Studio, I don't know how to connect to it, it ...
0
votes
1
answer
3k
views
Fixed Length Field Export from SQL Server
How do I go about exporting SQL Server 2005 tables to a fixed length field text file, with one record per line? SQL seems to think fixed length is the only way to delimit records, i.e. fieldLen1 + ...
0
votes
1
answer
308
views
SQL Server 2005: Copy database failing with unhelpful error
> Event Name: OnTaskFailed Message:
> Operator: ***\administrator
> Source Name:
> ***_Transfer
> Objects Task Source ID:
> {9135C978-DD50-4418-A843-7E8FCE455181}
> ...
3
votes
5
answers
475
views
Executing SSIS package
I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business ...
3
votes
4
answers
2k
views
Unix and Triggering MS SQL Server Integration Services Jobs
We have an AIX server which contains a lot of data, and once a night we dump that data to CSV for import into MS SQL Server for reporting reasons.
At the moment, each step in the process is unlinked, ...
0
votes
2
answers
2k
views
Exporting/restoring Multiple SSIS DTSx packages to file system
Is there a way to export and import multiple dtsx packages from SQL Server 2008?
I'm trying to find a built-in way/free tool/script to automate right-clicking the package, selecting "File System" for ...
3
votes
3
answers
33k
views
Installing ONLY SSIS and not the whole SQL Server system?
I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008.
In addition to having SQL Server ...
0
votes
1
answer
337
views
sql server sp2 doesn't update ssis
the company i work for is installing a program which requires it to run on SQL Server Service pack 2 which uses SSIS to import data. I just installed SQL Server service pack 2 and I noticed it will ...
1
vote
1
answer
820
views
odbc connect to cluster node error
I recently installed SQL Server Integration Services onto one of the nodes of a single cluster thats running windows 2003 enterprise. When I attampt to create a system odbc connection to the database ...
3
votes
4
answers
6k
views
can SSIS connect to another sql server?
Can an SSIS package run on one SQL Server instance but process data that is located on another SQL Server instance? I'd like to know this before I attempt to install SSIS and require a possible ...
0
votes
2
answers
3k
views
how do you install SSIS on a cluster environment
I'm running SQL Server 2005 enterprise edition on a 2 node active-active cluster windows 2003 server. I go to add/remove programs, click on SQL Server and then the link for "to install a new ...
3
votes
3
answers
13k
views
SQL Server 2005: Copy SQL Server Agent Job?
I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
1
vote
1
answer
950
views
Why is my SSIS configuration update not being saved?
I asked this over on SO with little success. I was wondering if any SF folks had some insight...
I have a SSIS 2005 package that is up and running in our production environment. The package uses an ...