Rating Thread / Thread Starter	Last Post	Replies	Views
Multiple Time Dimensions Hello, I have two time dimensions, Calendar and Fiscal, and am trying to get a simple moving average calculation to work for both but can only get... Jay	07-15-2005 11:16 AM Jay	1	63
DTS Package Export? I created a DTS package on my local machine for development reasons, but now i need to take the package i created and move it to another Server.... mfritts253	07-15-2005 09:44 AM mfritts253	2	64
import txt into new table i need to import bunch of text files into SQL server, and i want to import each file into its own (unexisting) table. i tried with DTS, it works... darionis@hotmail.com	07-15-2005 09:35 AM Francesco Anti	1	63
Activex Export Multiple files hi all, i am after some help please, what i am trying to do is export a table to many text files. the way i would like to do this is to read all the... samatthews@ntlworld.com	07-15-2005 08:46 AM samatthews@ntlworld.com	0	56
How to create a log that return error message whem my store procedure failed? Hi I'm using Sql Server 6.5 and I have a sp that is called all the time. This procedure inserts a row in a table. I saw that sometimes the row is... Catthy L via SQLMonster.com	07-15-2005 08:31 AM Catthy L via SQLMonster.com	0	72
Reading Excel File column names Hello Everyone, I have a excel file with variable column header information and one of the column header has some data which needs to be read. I... Yunus's Group	07-15-2005 07:35 AM Reza	1	63
Error Handling Im calling a package from another package by using a ActiveX task, the command Im using is oPKG.Execute. If the package that Im calling errors out... molson	07-15-2005 07:20 AM molson	0	63
How to use UPDATE in DTS ? Hi, I have to get some data in my Sql Server database and update one another table in my Oracle database with these data (using DTS). 1) What is... Ed	07-15-2005 12:14 AM Allan Mitchell	2	77
Insert Row into IBM DB2 I'm creating a DTS Package that will move data from a SQL Server table into a DB2 table to be processed on the mainframe. I'm using an Execute SQL... JDS via SQLMonster.com	07-14-2005 04:48 PM JDS via SQLMonster.com	0	62
SET CONCAT_NULL_YIELDS_NULL OFF in 2005 SSIS Execute SQL Task need to SET CONCAT_NULL_YIELDS_NULL OFF, but while my query works fine in SQL Server 2005 Management Stuido, it does not work in... Greg	07-14-2005 04:15 PM Greg	2	68
Automatically create table name Hi All, I want to rename table automatically .How can i do this ? from example table name is Customer --> wants to rename every day as Customer... Kris	07-14-2005 03:41 PM Ilin S via SQLMonster.com	4	74
DTS pckg for export excel into temp SQL tbl to use in SP for data manipulation I need to create a DTS package , which will export data from excel into temp table in MS SQL and then use stored proc to manipulate this data from... Ilin S via SQLMonster.com	07-14-2005 01:40 PM Ilin S via SQLMonster.com	0	52
DTS Workflow question I have the following code that I used out of #218 at SQLDTS.com. It sets the workflow for branching within a DTS job. --begin code ' Name of the... Blasting Cap	07-14-2005 11:50 AM Blasting Cap	0	87
Only the first raw is copied... Hello! I'm trying to use a DTS to export some columns of an excel file into a table. I can preview several rows (as supposed) in the "Transform Data... -- Girofle Girofla	07-14-2005 10:46 AM -- Girofle Girofla	0	77
Cannot immediately select after executing DTS Hi, I am using C# to execute a stored procedure to execute a DTS. The DTS executes alright. It is a simple DTS to do a direct copy from excel to SQL... Jordan	07-14-2005 07:43 AM Jordan	6	85
80040427 Error "Execution was cancelled by user" I have a package that run a number of other packages When the package is run in full the whole process works correctly, but when each step of the... Tractor boy	07-14-2005 02:01 AM Tractor boy	2	334
ActiveX Task Hangs on Server I currently have a DTS package that used to work on our server. The ActiveX task hangs on one server, runs on a different server and will... Gregory C. Quinn, Jr.	07-13-2005 04:15 PM Allan Mitchell	3	84
Export info from a table to a csv file using DTS Hello all, I am running MS SQL Server 2000 - I think service pack 3 - (how can i find that out) I am trying to use the export wizrd to copy certain... John Lloyd	07-13-2005 04:14 PM Allan Mitchell	1	112
SQLDTS FTP and question after file retrieval I have a job where I ftp a text file from a site, and write it out to a folder on my server. In the step, I plan to delete the input file once it's... Blasting Cap	07-13-2005 03:59 PM Blasting Cap	0	94
How to Import Data from Excel /CSV file to SQl Datbase Table using DTS in VB.Net Hello, I have a excel and CSV file which has data exported from a table in SQl databse. I want to progrmatically using VB.Net transfer the data from... kd	07-13-2005 02:10 PM Allan Mitchell	1	95
Pass multiple parameters in Execute SQL Task I had written an earlier question about how to do a "where" clause inside an Execute SQL Task properties. I thought that I might be able to create a... Blasting Cap	07-13-2005 02:07 PM Allan Mitchell	5	81
Trying to pull data in SQL from a Platinum Database. Have date issues. The date in SQL shows up as 729089 Even in Excel the grid shows for eg. the data as 3/29/3896 when I format the date as a Date. I was provided the... Sam	07-13-2005 02:03 PM Allan Mitchell	3	64
Package returning errors when step's workflow set to DontExecuteTa I have a job that has a number of steps of which the last two are to be executed only if certain conditions are met. In the... Steve	07-13-2005 02:00 PM Allan Mitchell	1	67
Reading Column Name in Excel files in DTS Hello Everyone, I have a excel file that has a variable column header name. Meaning, one of the column name actually contains some data. So, during... Yunus's Group	07-13-2005 01:48 PM Yunus's Group	0	431
how to autogenerate ID field Trying to import a excel spreadsheet and I have setup the transform as such... Function Main() DTSDestination("id")= DTSDestination("fn") =... JasonMeyer	07-13-2005 01:06 PM Allan Mitchell	4	101
Reading Excel File column names Hello Everyone, I have a excel file with variable column header information and one of the column header has some data which needs to be read. I... Yunus's Group	07-13-2005 01:04 PM Yunus's Group	0	78
DTSRun Call from Unix ( 1 2 ) Need to execute DTSRun from a Unix box (no dos partition). Any ideas? Thank you in advance. sshaahin	07-13-2005 12:56 PM frank chang	11	271
Multiple workflow into one task Hi, I have an Email Task in my DTS package which has a number of 'Failure' workflows running into it from different parts of my DTS package. I want... Simon M	07-13-2005 06:52 AM Darren Green	1	73
general network error, but not for all tasks? Hi, I have a custom program which create an in memory DTS package. The program works fine and has been deployed in several computers. But on 1... Jéjé	07-13-2005 06:48 AM frank chang	3	77
DTS Query Hi All, Im trying to create an hyperlink inside a result column from an sql query inside an excel worksheet. If I type the text manually into a... jatinder.singh@clovertechnologies.com	07-13-2005 12:49 AM jatinder.singh@clovertechnologies.com	0	80
sql_variant and SQL Server 2005 Integration Services (DTS) I need to use a column with a sql_variant data type from a SQL Server 2000 table in a Data Flow Task without using the default conversion to DT_WSTR.... Greg	07-12-2005 06:20 PM Greg	2	86
Sequence of transforms? I have built a package of 9 transformations in SS2K. I am doing a couple of tasks up-front, naming variables, etc., and then I want the... Michael Kellogg	07-12-2005 05:57 PM Michael Kellogg	2	114
Identity field problems with DTS SQL 7.0 Can you use DTS to insert a CSV file into a SQL table that has an identity field? Without the identity field, data imports... DonSQL2222	07-12-2005 05:10 PM Bill Swartz	1	86
looping, importing the dirctory of excel files I read the artical "Looping, Importing and Archiving" by Allan Mitchell and "Import all files in a directory (Multi Step) By Darren Green". It is... megankiew@gmail.com	07-12-2005 04:37 PM Allan Mitchell	5	81
How to transfer Production Data to Reporting Data My current project now is how to synchronize (data transfer) between Production Database & Reporting Database using DTS, but I have no idea how to do... Resant	07-12-2005 02:14 PM Allan Mitchell	4	84
Parameters in Execute SQL Task properties I am working on a DTS job to do some file manipulation and renaming and so on in preparation for picking up a file from an FTP source. Based on a... Blasting Cap	07-12-2005 02:09 PM Allan Mitchell	5	77
DTS Task execution problem Hi All, My DTS Package was working fine. I need to add 4 new task into DTS. These new 4 task suppose to run first. So I added new task and setup... Kris	07-12-2005 02:00 PM Allan Mitchell	3	82
Executing Dynamic Properties Task using VBScript All, Is it possible to execute task in a task. For example my ActiveX Task sets global variable in a loop and other task (in the same package) reads... HKM	07-12-2005 01:52 PM Allan Mitchell	1	75
DTS Failing to open/run on Server Hi I have a series of DTS packages whgich were running ok as jobs on tyhe server. Something went wrong on friday and now I can't open/run them from... Jonathan Crawford	07-12-2005 01:16 PM Jonathan Crawford	4	90
Recover DTS job from msdb.mdf I've got the msdbdata.mdf and msdbdata.ldf files for a server that once had a DTS job that I'm trying to recover. The package was never saved (ugh),... ChrisA	07-12-2005 12:46 PM ChrisA	0	85
Pre source data function Hi, I would like to write a heading to the file before exporting the data to Text/Excel e.g. CompanyName Created Date CustomerID: Invoice... Ed	07-12-2005 11:46 AM Ed	0	78
ArticleID=889170 I am getting the error message "Not enough storage available to complete operation" when trying to use the lookup feature in a DTS package. ... Kay	07-12-2005 09:56 AM Kay	2	86
Passing Global Variables, type (date) via DTSRun Dear All, in our currwent software project we use lots of DTSRun commands to start several DTS packages that have been created by several... Christian Kuntz	07-12-2005 09:50 AM Christian Kuntz	4	119
SQL to text file DTS Converts "1" to "true" I have a DTS package that takes a simple select statement and outputs it to a text file. The SQL references several columns whose value is 1 or 0. ... Jeffrey K. Ericson	07-12-2005 09:50 AM Jeffrey K. Ericson	1	57
URGENT: can't redistribute DTS runtime files???? Hi, I have created my own application and I'm using DTS. I have an installation package to automatically install the application. but the... Jéjé	07-12-2005 07:42 AM Darren Green	3	267
odd/even pk's on 2 databases and DTS Hi everyone. I'm wondering if any one can help me. I'm fairly new to DTS and made a blindingly obvious mistake the other day. I currently have to SQL... James@InnoCreate.com	07-12-2005 07:39 AM Darren Green	1	84
odd/even pk's on 2 databases and DTS Hi everyone. I'm wondering if any one can help me. I'm fairly new to DTS and made a blindingly obvious mistake the other day. I currently have to SQL... James Brand	07-12-2005 07:29 AM James Brand	0	60
SSIS packages and SQL Express Will I be able to run SSIS packages on a computer with SQL Express, or will they only work with SQL Server 2005? - Kristoffer - Kristoffer Persson	07-12-2005 07:26 AM Darren Green	1	73
Lookup or not Lookup? Hi, I hope someone can help. I have a dts package in SQL Server 2000 with 2 connections. table A in database 1, table A in database 2. Basically I... loic_nospam@yahoo.com	07-12-2005 07:24 AM Darren Green	1	80
Re: Deploy VB.Net application with SQL Database * Sent via Developersdex http://www.developersdex.com * awadh asdf	07-11-2005 11:38 PM awadh asdf	0	78

Page 121 of 258

121

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off