No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Answered0VotesExport to a text file, then name the exported file the date is was exported, then zip
Hi folks Any help on my request would greatly be appreciated. We are trying to maintain the growth of a particular table, by exporting and ...1 Replies | 4798 Views | Created by koln - Tuesday, July 03, 2007 5:09 PM | Last reply by jwelch - Tuesday, July 03, 2007 8:43 PM -
Answered0Votessetting the disable property with an Expression on an Analysis Services Processing task
Hi guys wonder if you can help me. I have been useing expressions to test weather to run tasks in SSIS or not on the value of a variable. This had been ...1 Replies | 3073 Views | Created by Alexis M Coles - Wednesday, July 30, 2008 3:20 PM | Last reply by Rafael Salas - Wednesday, July 30, 2008 3:35 PM -
Answered0VotesDate is in a different format
Hi Team, I have date in the format "2010-09-08T20:44:45.2570661Z" in the file. how do i convert it to load into the ...4 Replies | 3459 Views | Created by Eswararao C - Tuesday, January 04, 2011 10:35 AM | Last reply by Jamie Thomson - Tuesday, January 04, 2011 2:31 PM -
Answered0VotesPassing Parameter into many inner SQL Statements inside Execute SQL Task inside For Each Loop
Friends, I need to pass a value through a parameter to execute a set of SQL Statements inside a Execute SQL Task which is inside a For Each Loop. Inside the ...11 Replies | 5398 Views | Created by Raajkumari - Tuesday, February 01, 2011 3:53 PM | Last reply by Raajkumari - Friday, March 04, 2011 6:26 PM -
Answered0VotesBizarre DTS variable issue with SSIS 2008 R2
0 These constraints go to script tasks, in both I display the contents of a string variable using MessageBox.Show, if the execution path goes to one of these tasks I get a path ...1 Replies | 1330 Views | Created by ChrisAdkin - Wednesday, February 08, 2012 3:12 PM | Last reply by ChrisAdkin - Wednesday, February 08, 2012 3:32 PM -
Unanswered0VotesFlat File Connection Manager
As I have a file whose delimiters can be different. I have need to change the delimiters and filename programatically. I have come across a way to change ...1 Replies | 3485 Views | Created by Madhattuer - Wednesday, June 27, 2007 9:53 AM | Last reply by jwelch - Wednesday, June 27, 2007 8:29 PM -
Answered0VotesMove instance from one cluster to another - ssis worries ??
Hey Folks, Im planning to Move an instance from one cluster to another tomorrow. Instance name to stay the same, see my thread ...7 Replies | 2861 Views | Created by ilikefondue - Friday, December 02, 2011 7:35 PM | Last reply by ArthurZ - Wednesday, December 07, 2011 12:58 AM -
Answered1VotesError in e-mail task expression using DT_WSTR
In a e-mail task I use the expression "Loop " + (DT_WSTR,3)@[User::loadCounter] + " Server: " + @[System::MachineName] + " Time: " + (DT_STR, 50, 1252) GETDATE() The ...2 Replies | 2409 Views | Created by anarchipur - Friday, June 17, 2011 2:37 PM | Last reply by Phil Brammer - Friday, June 17, 2011 5:17 PM -
Unanswered0VotesHow to keep some destination records when re-loading a table from a source ?
Hi, I'm new to SSIS and need to get a solution up an running fairly quickly, so would appreciate some ...7 Replies | 2472 Views | Created by Ross Watson - Friday, September 26, 2008 2:16 PM | Last reply by jwelch - Tuesday, September 30, 2008 3:11 PM -
Unanswered0Votesproblem on loading data to db2 destination using oledb in ms-ssis.
hello i am performing the ETL on the as400 db2 database using ms- dts,ssis. i have built the connection b/w as400 and source to extract data from as400 to staging ...2 Replies | 3860 Views | Created by Umesh_DB2 - Monday, January 01, 2007 9:23 AM | Last reply by Phil Brammer - Monday, January 01, 2007 4:24 PM -
Answered0VotesUsing ODBC to connect to foxpro tables to output to SQL tables
I'm new to SSIS and I have some foxpro tables that I need to import into SQL tables. I think I need to use an ODBC since my tables are in foxpro 2.6. I think I have the ODBC ready where ...14 Replies | 3805 Views | Created by BAMA1 - Thursday, September 09, 2010 2:38 PM | Last reply by AmcAmx - Tuesday, September 21, 2010 10:10 PM -
Answered0VotesProblem Pulling From Access DB
We are currently moving existing SSIS packages from one server to another. The former server is 32 bit and the new server is 64 bit clustered (not sure if that's relevant or not, ...4 Replies | 9039 Views | Created by Jay8 - Friday, March 23, 2007 8:52 PM | Last reply by AugusHsu - Thursday, October 27, 2011 6:20 AM -
Answered0Votesuse report to show ETL's error step when failed
Hi all, Currently, our ETL sometimes will fail, however the error message is very general, I want to use SSRS to show ETL's step. From the report, i will know which steps have ...2 Replies | 605 Views | Created by Jeddd - Wednesday, December 19, 2012 4:09 AM | Last reply by Eswararao C - Wednesday, December 19, 2012 5:39 AM -
Answered1VotesDeleting multiple packages
Hi, Does anyone know of a short way to delete multiple SSIS packages that have been deployed to SQL Server? I know you can right click and Delete single packages, but that takes ...11 Replies | 4486 Views | Created by Bisquite - Monday, July 19, 2010 5:42 PM | Last reply by hemalatha manickam - Thursday, April 12, 2012 7:03 PM -
Answered1VotesUse SSIS to promote existing SSIS packages
Hi - the company I am working for likes to do all solution promotions using SSIS. So the first step might run a SQL script that builds tables, the second step might run a SQL step that populates some ...6 Replies | 3890 Views | Created by kristl tyler - Wednesday, October 14, 2009 4:18 PM | Last reply by kristl tyler - Tuesday, November 03, 2009 12:58 PM -
Answered0VotesExecute process task of BAT file fails after closing DTS package
Hi All I have a DTS package which uses an "Execute Process Task" to run a BAT file which is on the server's C:\. What happens ...2 Replies | 2842 Views | Created by csc bounce - Monday, June 02, 2008 10:09 AM | Last reply by csc bounce - Monday, June 02, 2008 3:12 PM -
Answered0VotesHow to determine actual controls from the error message.
Semi complicated set of 14 lookups before I insert into a table in the DW. OLE DB Destination control goes red in execution with this error. Error 2 Validation ...4 Replies | 1144 Views | Created by Stephen.Russell.Ring - Wednesday, May 16, 2012 1:07 PM | Last reply by Eileen Zhao - Tuesday, May 22, 2012 9:06 AM -
Answered1VotesHow to Extract data from Twitter or any web page
I want to extract data from Twitter to database table. Do any guide me to achieve this. Thanks Mahadevan V. Mahadevan5 Replies | 4988 Views | Created by RV Mahadevan - Friday, June 11, 2010 4:35 AM | Last reply by Darren Green SQLIS - Friday, June 11, 2010 8:51 AM -
Discussion1VotesSSIS Data Flow Completes Successfullywithout doing anything
I am doing a dataflow task in SSIS and the source is a stored procedure. When I start the package the Data flow task truns green in a second without actually doing any insert in the destination. All ...3 Replies | 4843 Views | Created by FARHAN ANSARI - Wednesday, April 01, 2009 10:43 AM | Last reply by jwelch - Thursday, April 02, 2009 12:41 AM -
Unanswered0VotesHow to insert value in a table
Actually I have one query select min(seq_Id) as minseq_id from stage I stored this value into variable called minseq_id with ...5 Replies | 2538 Views | Created by Aminesh - Wednesday, August 18, 2010 3:01 PM | Last reply by Todd C - Wednesday, August 18, 2010 5:03 PM - Items 1 to 20 of 49859 Next ›


