]]>The post SQL Export to Excel file column? appeared first on IT Answers.
]]>http://itknowledgeexchange.techtarget.com/itanswers/export-to-excel-file-column/feed/2.dts and .dtsx config files in SQL Server 2005http://itknowledgeexchange.techtarget.com/itanswers/dts-and-dtsx-config-files-in-sql-server-2005/
http://itknowledgeexchange.techtarget.com/itanswers/dts-and-dtsx-config-files-in-sql-server-2005/#respondThu, 16 Apr 2009 09:40:46 +0000Hi 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?

]]>http://itknowledgeexchange.techtarget.com/itanswers/dts-and-dtsx-config-files-in-sql-server-2005/feed/0update the tables in to two server using a single ssis packagehttp://itknowledgeexchange.techtarget.com/itanswers/update-the-tables-in-to-two-server-using-a-single-ssis-package/
http://itknowledgeexchange.techtarget.com/itanswers/update-the-tables-in-to-two-server-using-a-single-ssis-package/#respondWed, 04 Apr 2012 10:04:29 +0000i 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. …ckage...

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

]]>http://itknowledgeexchange.techtarget.com/itanswers/maximumerrorcount/feed/0Migrating DTS packages that use mainframes source to SSIShttp://itknowledgeexchange.techtarget.com/itanswers/migrating-dts-packages-that-use-mainframes-source-to-ssis/
http://itknowledgeexchange.techtarget.com/itanswers/migrating-dts-packages-that-use-mainframes-source-to-ssis/#respondMon, 12 Apr 2010 06:26:33 +0000I 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?

]]>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?

]]>http://itknowledgeexchange.techtarget.com/itanswers/sql-2005-ssis-64-bit-excel/feed/0where clause condtion as a variable (SSIS 2005)http://itknowledgeexchange.techtarget.com/itanswers/where-clause-condtion-as-a-vairable/
http://itknowledgeexchange.techtarget.com/itanswers/where-clause-condtion-as-a-vairable/#commentsTue, 16 Feb 2010 21:51:12 +0000 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,

]]>http://itknowledgeexchange.techtarget.com/itanswers/where-clause-condtion-as-a-vairable/feed/1SSIS Import from Multiple Databaseshttp://itknowledgeexchange.techtarget.com/itanswers/ssis-import-from-multiple-databases/
http://itknowledgeexchange.techtarget.com/itanswers/ssis-import-from-multiple-databases/#respondMon, 13 Jul 2009 21:57:20 +0000How 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?

]]>http://itknowledgeexchange.techtarget.com/itanswers/ssis-import-from-multiple-databases/feed/0Why is SSIS xml variable in escaped format?http://itknowledgeexchange.techtarget.com/itanswers/why-is-ssis-xml-variable-in-escaped-format/
http://itknowledgeexchange.techtarget.com/itanswers/why-is-ssis-xml-variable-in-escaped-format/#respondWed, 01 Jul 2009 19:44:29 +0000In 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 marks are escaped...

]]>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 marks are escaped (“). I’ve tried both the OLEDB and the ADO.net connection managers. I want to pass the xml result to a web service using the Script task. My question is do I need to get rid of those escaped doublequotes first OR how can I avoid them in the first place OR does the script task silently handle this? I just do not understand why SSIS messes with xml when I tell it the resultset must be in xml format even though I’m storing it in a string variable. Please be so kind to educate me. Thank you.

]]>http://itknowledgeexchange.techtarget.com/itanswers/why-is-ssis-xml-variable-in-escaped-format/feed/0iSeries to SQL Server via SSIS 2005http://itknowledgeexchange.techtarget.com/itanswers/iseries-to-sql-server-via-ssis-2005/
http://itknowledgeexchange.techtarget.com/itanswers/iseries-to-sql-server-via-ssis-2005/#respondThu, 05 Mar 2009 16:56:19 +0000We 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.