Hello there I have an integration services on far server. How can i access to integration services from my local computer?

Roy Goldhammer

09-09-2008 04:22 AM
Roy Goldhammer

Hi I have a For Each Loop that iterates over the nodes in an XML document. The For Each Loop contains a Sequence Container that wraps all the...

Vikas Manghani

09-07-2008 11:34 PM
Vikas Manghani

Morning All, I've got a DTS package that takes data from a Pervasive Database into a SQL Database. In the query I am using a WHERE clause that...

spshaffer@adelphia.net

09-06-2008 09:43 AM
spshaffer@adelphia.net

Can I use a DTS package to output to a .txt file? How? And can I somehow get the record count previous to writing the .txt file and put the record...

PSULionRP

09-05-2008 01:20 PM
PSULionRP

When using the Import Data Wizard in SQL Server, part of the process allows me to enter a query to import data from the source server and database. ...

Tim Ponds

09-04-2008 09:20 PM
Tim Ponds

Hi, I have a DTS package that is run once a month using a text file sent to us by our customer. Each month we get a new data file and it's placed...

Jim Moberg

09-04-2008 05:44 AM
matteus

I am running SQL Server 2000 SP4. My problem is I need to run sp_reinitsubscription for multiple publications. I try setting up a DTS that has...

Hoardling1 via SQLMonster.com

09-04-2008 05:00 AM
matteus

I have a dts created in SQL 2000 that loads an INI file to read some file location. To make it work in different environment , i have to manually...

ramaswamykarthik via SQLMonster.com

09-03-2008 05:28 AM
ramaswamykarthik via SQLMonster.com

Does exist a simple task (or manner) to export data from a MOSS list to a SQL table by using SSIS 2008? Thanks

Pasquale

09-02-2008 08:41 AM
Pasquale

When trying to upload German characters from an Excel sheet to a database table using DTS package the following happens: Characters can be read in...

BoB Teijema

09-01-2008 11:54 AM
BoB Teijema

Dear All I am going to develop a routine which will send a status report of a sql server as an xml document. The document will include a list of...

allan.martin@gmail.com

09-01-2008 09:52 AM
allan.martin@gmail.com

I'm adding SSIS 2005 on two node cluster. I'm using SQL Server 2005 Enterprise Edition 64-bit. In the first node I have added correctly SSIS: I have...

Pasquale

09-01-2008 06:27 AM
Pasquale

Hi experts Hard time always arise when deploying SSIS package at Vmware. At Vmware, the connection string configuration is not able to read from...

Daniel

08-29-2008 08:53 PM
Daniel

Is there a tutorial on the easiest way to export an SQL Server database's tables into and Access database (all tables without having to do them one...

Gerhard

08-29-2008 04:27 AM
Charles Wang [MSFT]

Easy question for the folks… I have a SQL Server (2000) with .txt data files that I need to send cross country to another SQL Server. This needs to...

Mark

08-28-2008 05:29 PM
Mark

Hi experts, i just realize the SSIS Execute Package utility has one feature to allow manual add ConfigFile location for overwriting the default...

Daniel

08-28-2008 12:26 PM
Daniel

hi experts, i use xml configuration with no password protected n tried to deployment at server side, but fail. When run the package, it stated...

Daniel

08-28-2008 11:21 AM
Daniel

Hi My Workstation is running Microsoft Windows XP Professional Version 2002 Serice Pack 3 The Sql Server is running Microsoft Windows 2000 Advanced...

Herbert Schroder

08-28-2008 10:03 AM
Herbert Schroder

I'm doing some database maintenance by erasing DTSs and jobs that are needed anymore. I've noticed that there are jobs that don't have a...

VMI

08-28-2008 02:55 AM
matteus

Do you live in the UK? Do you want to come to a free, no-string attached, SQL Server conference? Then come to SQLBits! Registrations are now open...

Chris Webb

08-27-2008 03:25 PM
Chris Webb

Hi, I want to move an Axapta database located on an Oracle databaseserver to a Microsoft SQL 2005 server. I would like to avoid writing an...

Kent

08-27-2008 07:04 AM
glibs

Is there a way to specify the SQLCommand for an excel destination dynamically in SSIS? It appears the "From Variable" option is limited to sheet...

Ron Ruble

08-26-2008 03:44 PM
Ron Ruble

Hello i have an SSIS package that contains two execute sql tasks, and one data flow task. when i run the sql script on its own in the MS SQL...

Mike_Walrus

08-25-2008 07:16 PM
Mike_Walrus

Trying to use WMI Reader task to get windows events. The output is going to flat file, however I cannot import into SQL table because of...

Chris

08-25-2008 06:00 PM
Chris

My ultimate goal is to use the Transfer SQL Server Objects Task to copy schemas only (no data) all the objects (tables, procedures, views, etc.)...

Larry

08-22-2008 04:17 PM
Larry

I'm importing a CSV file into a database. The file includes a couple of date columns. I've added a Data Conversion step in my Data Flow to convert...

Aardvark

08-22-2008 02:06 PM
Aardvark

I have an “Execute SQL Task” object in my SQL 2005 Integration Services Project. The relative properties are: ResultSet ...

Cam

08-22-2008 01:34 PM
Todd C

I have a sql server 2000 job that is just doing an execution of a DTS pkg. When you look at the syntax in the step of the job I see something...

DTS Newbie

08-22-2008 10:12 AM
Ed Enstrom

Hi, I wanted to make sure you were all aware of these upcoming events. There is a seminar in Predictive Analytics on Sept 24-25 in Chicago, and two...

Elise Johnson

08-22-2008 01:42 AM
Elise Johnson

Hi All Techies, I have created one DTS to copy records from table1 (which is on Oracle server) to table2 (on SQL Server 2000). In the first...

Sur

08-21-2008 11:12 AM
Sur

Hi I have the code below in a dts package to read any file from a particular directory - I get error with My.Computer.FileSystem.... - How can I...

jojo123

08-21-2008 10:23 AM
jojo123

Hello, Is there (on internet) an official reference for the syntax to use trying to query data from an excel 2003 database in a DTS package ? here...

Roger Tranchez

08-21-2008 08:59 AM
Charles Wang [MSFT]

Hi, all, I have the following scenario: I have one file with multiple lines, but each table's record may contain data regarding more than one line...

Andre

08-20-2008 01:19 PM
Andre

I have a large number of DTS packages on my 2000 servers and need to catalog them all. Our developers omitted that step when they created them over...

Moishe Much

08-20-2008 11:50 AM
Moishe Much

I have several instances of SQL Server 2000 and each has a large number of DTS packages. I need to catalog the details of each DTS...

Moishe Much

08-19-2008 04:12 PM
Moishe Much

hi experts, i am trying to look for answer on deploying SSIS with all connections string configuration into a SQL Database. May i know wat & how is...

Daniel

08-19-2008 08:41 AM
Todd C

Hi, all here, I will have to update all connection managers information for all of our DTS packages which is daunting. Instead of going through each...

Helen

08-18-2008 05:44 AM
Helen

SQL2005 EE How do I use the Fuzzy Lookup or Grouping transformation to send in a row from the oltp app? In other words call it like an API object....

Chris

08-14-2008 09:32 PM
Chris

Hello there I need to create dinamic report on sql server which provide the data on excel. one of the fields will be name of sheet in excel...

Roy Goldhammer

08-14-2008 09:34 AM
Roy Goldhammer

Hi, I've been trying to store a connection string in any kind of configuration. It seems SSIS never stores the password there. Do I really have to...

Axel Dahmen

08-14-2008 04:29 AM
Scho

Hi, I have a SSIS package In my source "data flow" task I have a stored procedure (sp_GetTrafficData) which gets the data and populates the table in...

praveen

08-13-2008 12:39 PM
Todd C

Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are...

Brian Mahloch

08-13-2008 08:22 AM
Brian Mahloch

Are you looking for a Job in India??? You have experience in Java, Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a minute and...

Naveen

08-12-2008 03:19 PM
Naveen

I am trying to pass a value from a stored proc output variable to a user variable in SSIS. When I define the variable as integer in both SSIS and...

Jim

08-11-2008 04:47 PM
fschmid

Hello, I've created simple SSIS package based on: http://www.sqlservercentral.com/articles/Analysis+Services/63382/ It works great from Business...

anxcomp

08-11-2008 03:49 PM
anxcomp

I've got > 300 very complicated SSIS packages which execute TSQL and stored procedures. SSIS Packages are executed by jobs and some are...

Cqlboy

08-08-2008 08:46 PM
Cqlboy

I have been having a hell of a time with running a dtsx package on my SQL server 2005. I designed the package on a development machine and through...

Mo

08-07-2008 11:00 AM
matteus

G'day, I have a DTS package that I store in a SS2000 server which I've also saved into a SS2005 server. I've modified the package using Enterprise...

peter.davey@austin.org.au

08-06-2008 07:00 PM
peter.davey@austin.org.au

HI I am only a newby with SSIS so this maybe a simple setting. I've created a solution in BI with a list of packages. i work on the solution...

nn

08-06-2008 05:45 AM
matteus

hello, attempting to execute a dts pkg. against an MSDE 2000 engine. However, receiving the following error: Description: SQL Server does not exist...

jim

08-05-2008 07:14 PM
jim