SSIS

passing data between two SQL Server databases

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...

Passing data between two SQL Server databases

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,...

SQL Express used for SSIS?

Can sqlexpress be used for SSIS Software/Hardware used: DELL 750 Poweredge server

Why is SSIS xml variable in escaped format?

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...

remove password from SSIS package

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.

Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

Writing directly ot iSeries optical drive

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...

Execute SSIS package in SQL Server 2005

how to execute SSIS package in sql server 2005

Migrating DTS packages to SSIS

What is the tool that migrates DTS packages to SSIS, and how effective is it?

Tool for migrating DTS to SSIS

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?

Delete names from an email list in SQL Server Integration Services

How can I delete names from an email list in SQL Server Integration Services?

split column into column

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.

SQL Export to Excel file column?

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

Using SSIS to populate SQL Server Data Warehouse

I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

iSeries to SQL Server via SSIS 2005

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.

SSIS and Microsoft Excel

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...

SSIS cache

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...

What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

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...

delete list in Sharepoint using SSIS

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

How to process partitions (Full) in analysis services

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...