I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables. Also we are not allowed to use the...
I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...
Can sqlexpress be used for SSIS Software/Hardware used: DELL 750 Poweredge server
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...
How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don't know the password. This package was created by an employee who left the company a couple of years ago.
How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS
We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is it prossible to...
how to execute SSIS package in sql server 2005
SQL Server 2005, SSIS Package, SQL Server 2005 Integration Services
What is the tool that migrates DTS packages to SSIS, and how effective is it?
What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?
How can I delete names from an email list in SQL Server Integration Services?
I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance
I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?
We have multiple DB2 Schema's that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.
I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...
We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn...
I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script...
Hello, I know how to load a SQL table into a Sharepoint list. My problem is I don't know how to delete it using SSIS. I am aware that there is a caml solution for this;however, i am unfamiliar with the language. Can anyone provide a solution for this problem? Thank you
Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 .... . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process...


