No announcements
Forums [ view all ]
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointPower PivotSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allAnnouncements for all ForumsForums Redesign - Q&A / DiscussionsSuggestions and Feedback for the ForumsWhere is the Forum For…?Forums Issues (not product support)Off-Topic Posts (Do Not Post Here)MSDN and TechNet Profile and Recognition System Discussions
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server Development
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
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
-
Answered0Votes
setting 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 -
Answered0Votes
Date 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 -
Answered0Votes
Passing 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 -
Answered0Votes
Bizarre 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 -
Unanswered0Votes
Flat 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 -
Answered0Votes
Move 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 -
Answered1Votes
Error 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 -
Unanswered0Votes
How 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 -
Unanswered0Votes
problem 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 -
Answered0Votes
Using 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 -
Answered0Votes
Problem 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 -
Answered0Votes
use 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 -
Answered1Votes
Deleting 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 -
Answered1Votes
Use 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 -
Answered0Votes
Execute 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 -
Answered0Votes
How 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 -
Answered1Votes
How 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 -
Discussion1Votes
SSIS 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 -
Unanswered0Votes
How 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 ›
