1
  • 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

    Shamilh10 pointsBadges:
  • .dts and .dtsx config files in SQL Server 2005

    Hi I have .dts and .dtsx config files. i want to execute these packages in the db server, can u tel me what are the steps required to attach and configure these packages for it to execute?

    Sangeeth30 pointsBadges:
  • update the tables in to two server using a single ssis package

    i have 2 servers server A and Server B.i have written a package in server A.i want to update the tables in both server A and B.when i execute the package from BIDS it is working fine when i schedule the package in agent job i am getting the below error.  Executed as user: RICRDWDEVSYSTEM....

    Knowledgesharing5 pointsBadges:
  • MaximumErrorCount

    HOW DO I CHANGE THE MaximumErrorCount IN SSIS

    Vercom5 pointsBadges:
  • Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

    Jwalini5 pointsBadges:
  • SQL 2005 SSIS 64 bit EXCEL

    How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?

    Oldmickey65 pointsBadges:
  • where clause condtion as a variable (SSIS 2005)

      Let's say we have this query   select * from customer where customerid = '1'   My question is can we create this "customerid = '1'" condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,

    SSISquestio5 pointsBadges:
  • SSIS Import from Multiple Databases

    How do I iterate over a series of databases with identical structure and import from a seris of tables within each using the SSIS ForEach facility?

    RobH5 pointsBadges:
  • 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...

    PaulDav5 pointsBadges:
  • 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.

    Oldmickey65 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following