SQL Server Integration Services, used for data migration in and out of Microsoft SQL Server
0
votes
1answer
26 views
SQL Server with one ethernet output and Webserver with another ethernet output
Scenario:
I have one server which is virtualizated using VMWare ESXi. Specs:
Windows Server 2008 R2
SQL Server Standard 2012
IIS 7.5
Hosting a MVC and a Webform application (using Reporting ...
0
votes
0answers
16 views
Running SSIS from workstations
I have to make a migration from SQL2000 to SQL 2008 R2. I currently have a few DTS packages that I run from user workstations to create some CSV files. They simply run a batch file on the WS that ...
0
votes
0answers
35 views
moving data from SSIS to As400 using IBM DB2 UDB OLEDB provider, failing due to special symbol “–” called endash ANSI value 0150 [closed]
I am getting error while moving data from SSIS dataflow task to AS400 using provider "IBM DB2 UDB for iseries IBMDASQL OLEDB provider" , it was running fine,suddenly starts failing I noticed that the ...
1
vote
0answers
23 views
What does this setting do when copying SSIS packages? “Duplicate package folder structure on destination for selected packages”
What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder ...
0
votes
1answer
588 views
MySQL ADO.NET Connector & MSSQL Integration Services
Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention.
I ...
0
votes
1answer
2k views
SSIS DSN Not Showing as ODBC Data Source
I have been following the directions here:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4
And ran into a problem where my System DSN ...
0
votes
0answers
156 views
Using SSIS to Replicate a MSSQL Dataview to MySQL
I am wondering what the best approach would be to replicate a dataview or query using SSIS 2012 on a windows machine to a MySQL database server running linux.
I installed the MySQL odbc connector ...
0
votes
1answer
216 views
SQL server agent job to execute SSIS package fails, package succeds if run manually
I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
2
votes
2answers
257 views
Why does SQL 2005 SSIS component install fail?
I am trying to install SSIS on our production SQL 2005 SP2 box. Each time I try, the install/setup screen results in failure, starting with the native client, and moving on down. Screen shots below ...
3
votes
1answer
232 views
Distributed and/or Parallel SSIS processing
Background:
Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
0
votes
1answer
199 views
SSIS package hangs on Setting Source Connection
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via ...
1
vote
1answer
732 views
The package failed to load due to error 0xC0011008 Error Loading from XML
Environment:
Windows Server 2008 SP2 Enterprise Edition 64-bit
SQL Server 2008 SP3 Standard Edition 64-bit
Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
0
votes
2answers
250 views
How to copy files to destination system through a specific LAN card?
I want to copy database backup from my running DB Server to Backup server. The source server has two LAN cards connected through their own IP address. One LAN card is used to connect to the ...
0
votes
2answers
216 views
OpenSSH and remote invocation
Before I ask the questions, I have to provide some context information...
I have a SSIS server which invokes a SSIS package. The SSIS package copies a file to a file server. After the copy action, ...
2
votes
3answers
2k views
How can I make my SSIS process consume more resources and run faster?
I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports.
I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server ...
0
votes
1answer
380 views
Error with SharpZipLib in Script Task SSIS 2008
I am trying to create a script which can Zip any file on the fly. For this a DLL SharpZipLib i have used. But unable to run the Package. Following code i found on the internet which i have used as is ...
1
vote
1answer
62 views
Edit SQL Server SSIS Package
I ran the Export wizard to output some data to Excel, and I saved the package to run agan later. I now want to edit the SQL used to generate the Excel, but it is not clear how I do this.
The package ...
1
vote
2answers
62 views
Is there a performance hit when using an external URL rather than an internal IP to address a server in SSIS?
I'm running SQL Server Integration Services (SSIS) packages in SQL Server agent every day. I've been monitoring the performance of the packages and see a lot of network activity in Resource Monitor. ...
1
vote
0answers
255 views
SSIS on W2K8 R2, SQL Server 2008 SP2 and Oracle
I'm in the process of migrating an old SQL Server 2000 SP4 on Windows 2000 to a new SQL Server 2008 SP2 on Windows 2008. In the old server we have a DTS that does some simple tasks against an Oracle ...
0
votes
2answers
202 views
SSIS Configuration problem: not returning SQL Server Table config values
I have a package that runs fine on my dev machine but in production the Config seems to stop working. I'm using SQL Server Table configuration to pull a value from a table and populate a variable. My ...
0
votes
2answers
193 views
Automatically set up user's subscription in SSRS
I have a very simple report in SSRS that is just a table with three columns, an object name, client account, and expiration date.
In my report, I include a filter by UserID to limit the data to just ...
0
votes
1answer
334 views
Possible to connect securely to remote MySQL using SSIS?
I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL ...
0
votes
1answer
842 views
Export Import error 'SSIS Data Flow Task could not be created' … registering DTSPipeline.dll, cannot create task “STOCK:PipelineTask”
I'm about to throw in the towel on this one.
Running SQL Server 2008 enterprise on Windows 7 x64. Can't get past this issue.
When I try to Import / Export Data from databases through SQL Server ...
0
votes
1answer
319 views
SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access
Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
2
votes
2answers
63 views
SQL 2005 SSIS and Package
If I have a SSIS Package created in VS 2005 and asked to install and setup this package. Does the server that is going to run this SSIS package have to have SSIS installed? I am 99% sure this is yes, ...
0
votes
2answers
686 views
Two way synchronization with SSIS?
Can I use SQL Server Integration Services (SSIS) to create a two-way synchronization between tables in two different databases? I am using SQL Server 2008 R2.
If it is possible, then how do I handle ...
0
votes
1answer
100 views
MSSQL: SSIS 2005 transfer logins task
I created an SSIS package to transfer logins from one server to another in SQL 2005 SSIS project using BIDS.
I want to transfer all packages but skip 3. So I changed the maximum number of error ...
2
votes
1answer
444 views
Execute SSIS package from a SQL Agent on another server
Here's my situation:
I have two servers, Server A has the Database Server installed and the SQL Agent (SQL Server 2008 Enterprise Edition, 64-bit). Server B has a vendor specific application that ...
1
vote
1answer
199 views
MSSSQL: SSRS, SSAS, SSIS edition
How can I know which edition of SSRS, SSAS and SSIS service is installed on a server?
Finding database edition is easy but how to find edition for other SQL services?
Any help please?
Thanks in ...
1
vote
1answer
300 views
PostgreSQL - Using COALESCE keyword in SSIS
When I am trying to use the COALESCE key word in an OLE DB Source control, it always returns a negative number in the results set.
I am using a Native OLE DB\PostgreSQL Native Provider as a ...
1
vote
1answer
142 views
How do I filter duplicates from a sharepoint list using ssis
I have successfully connected a sql data base to a sharepoint list using ssis. The problem is that every time I run the project all the data gets dumped into the list and causes duplicates. Is there ...
2
votes
1answer
123 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
1answer
40 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
2answers
453 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
3answers
393 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
1answer
430 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
3answers
790 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
1answer
148 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 ...
0
votes
1answer
240 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
2answers
828 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
1answer
690 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 ...
2
votes
2answers
3k 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
1answer
174 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
1answer
1k 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 ...
4
votes
2answers
3k 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
2answers
303 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
1answer
25 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 ...
2
votes
2answers
5k 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
1answer
370 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
1answer
1k 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 + ...
