Hi when i try to import data from an excel sheet i get this error for some fields in the table like name,No,date... can any suggest the possible...

Arohan

08-07-2007 04:26 AM
Arohan

Hello, I have a flat file source with ragged right format. It has three columns. My package fails when the last column has null values. It says...

=?Utf-8?B?QXJqdW4=?=

08-06-2007 11:22 PM
=?Utf-8?B?QXJqdW4=?=

I have a package that executes just fine when i select 'execute' When i go to schedule it, the corresponding job is created. But when i run the job,...

TroyS

08-06-2007 08:59 PM
Freddy Rios

is it possible to import data from Excel 2007 (.xlsx files) into SQL Server from SSIS? The Excel Source only gives up Excel 97-2005 (plus the old...

bmwbase-newsgroup@yahoo.com

08-06-2007 01:46 AM
bmwbase-newsgroup@yahoo.com

I set up a DTS Package Step to run when the previous step fails. The previous step fails but the next step does not run. Fail on First error is not...

=?Utf-8?B?cm1jb21wdXRl?=

08-03-2007 08:18 PM
=?Utf-8?B?cm1jb21wdXRl?=

Hi, I have a SSIS Package that uses SQL Server to store the config data. When the package executes I get these warnings (16 of them) there are 8...

=?Utf-8?B?VG9iaVI=?=

08-03-2007 10:54 AM
=?Utf-8?B?VG9iaVI=?=

Hi, How do I prevent permission wiped from my SPs when it comes to restoring dbs? Is there a way to assign permission globally? Thanks. -- bic

=?Utf-8?B?Ymlj?=

08-03-2007 08:19 AM
Russell Fields

Hi, does anyone have an opinion as to where packages should be saved? I am using the file system at the moment but I've read that it's more secure...

=?Utf-8?B?UGFub3MgU3RhdnJvdWxpcy4=?=

08-03-2007 02:12 AM
inkyneil@gmail.com

last week I created a ssis package to export to a flat file. it adding the cr lf today I create a new ssis and it is not adding the cr lf and if i...

=?Utf-8?B?dGRy?=

08-02-2007 04:26 PM
=?Utf-8?B?dGRy?=

Hi, I have a batch file, copies a xls file for one dir to another and delete source file. This works in DTS package, but when I schedule the...

=?Utf-8?B?dGhhbmtzZm9yaGVscA==?=

08-02-2007 02:44 PM
Russell Fields

From BOL: mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\adminsql.chm::/ad_impt_bcp_0fqq.htm "...However, it is only...

=?Utf-8?B?TWlrZSBXaGl0aW5n?=

08-02-2007 11:21 AM
rshivaraman@gmail.com

Hi, I am quite new to SSIS but inherited a package written by my predecessor to maintain. The SSIS Mater pckage runs nearly 6 to 7 DTS packages...

=?Utf-8?B?Uks=?=

08-01-2007 04:28 PM
=?Utf-8?B?Uks=?=

Hi, We have over 5000 Dts packages being used in a massive SAP Data migration project. Is there a limit to the number of packages that can be define...

=?Utf-8?B?U2NvdGNoeQ==?=

08-01-2007 01:38 AM
=?Utf-8?B?U2NvdGNoeQ==?=

I am running SQL Server 2005 and trying to make a copy of a database from Management Studio. Using the Backup wizard I go through all the steps...

=?Utf-8?B?V29vZHk=?=

07-31-2007 01:54 PM
=?Utf-8?B?V29vZHk=?=

I last developed SSIS in Oct 05 and this bug was a major irritant. 18 months later I'm revisiting the same deployment and it's annoying me all over...

=?Utf-8?B?RGF2aWQgTm9ybWFu?=

07-31-2007 09:39 AM
JPD

Hi, I am going to use the SQL Agent to schedule my SSIS Job. However, I only want my SSIS Package to run if a flag in a table has been set. This...

=?Utf-8?B?Qw==?=

07-31-2007 03:06 AM
=?Utf-8?B?Qw==?=

Hi All, I have a DTS package which exports database table into csv file daily but I want to include the date and time with the file name. file name...

=?Utf-8?B?UmVkZHk=?=

07-30-2007 06:44 PM
=?Utf-8?B?UmVkZHk=?=

I would like to run a ssis package and pass the filename as the parameter to the package. This is what I have worked out so far but notice the error...

=?Utf-8?B?ZmFyc2hhZA==?=

07-30-2007 02:36 PM
=?Utf-8?B?VG9kZCBD?=

I downloaded and installed the Microsoft .NET Data Provider for mySAP. I have pointed it at internal SAP instance. When I attempt to execute a task...

=?Utf-8?B?S2V2aW4gaW4gQ2hpY2Fnbw==?=

07-30-2007 02:04 PM
=?Utf-8?B?QWRlbXVzUHJpbWU=?=

Hi All: 1. I am generating an excel worksheet in my dts using an execsqltask. The thing is i am creating all 30 columns that could possibly...

rshivaraman@gmail.com

07-30-2007 10:42 AM
rshivaraman@gmail.com

Does anybody have a link to a discussion on using expressions in properties of a custom task? I'm developing a custom task to send a ticket request...

=?Utf-8?B?Qm9iZm9yZUFwcGxlcw==?=

07-30-2007 10:22 AM
=?Utf-8?B?Qm9iZm9yZUFwcGxlcw==?=

Can I call an SSIS Package from a Stored Procedure?

=?Utf-8?B?Qw==?=

07-30-2007 10:01 AM
Pawel Potasinski

Hi, Using SSIS, while importing (source i.e. .csv into destination i.e. sql server table), how is it possible to log the source COLUMN which causes...

=?Utf-8?B?ZmFyc2hhZA==?=

07-30-2007 07:38 AM
=?Utf-8?B?VG9kZCBD?=

Hi, Using SSIS, how is it possible to execute another ssis package and pass a parameter to it? For example, I would like to have a sql code that runs...

=?Utf-8?B?ZmFyc2hhZA==?=

07-30-2007 07:18 AM
=?Utf-8?B?VG9kZCBD?=

I create a Execute task that sets a boolean value of whether or not to continue the processing of the package How do I evaluate that variable to...

S

07-29-2007 12:36 AM
=?Utf-8?B?VG9kZCBD?=

Hi, I am using a foreach loop to go through the .txt files inside a folder. Using a variable I can pickup the filenames the loop is going through. At...

=?Utf-8?B?ZmFyc2hhZA==?=

07-29-2007 12:24 AM
=?Utf-8?B?VG9kZCBD?=

I am having trouble with the pivot transform. My desired results are not quite like the examples I have seen in the Help, and I am wondering if...

=?Utf-8?B?S2l0ZW51dERhdmU=?=

07-29-2007 12:18 AM
=?Utf-8?B?VG9kZCBD?=

I've got a delimited text file that aprox 5.5GB that I'm trying to load into a table on SQL 2000 (Windows Server 2003) and I keep getting the error...

crab.dae@gmail.com

07-28-2007 02:05 PM
crab.dae@gmail.com

(Re-Posted from another site with permission, since I have the same problem and he stated the issue well:) -- David Walker Kirk Shanks Uploading...

DWalker

07-27-2007 11:50 PM
dan.rei1@verizon.net

SQL Server 2000 SP4. I built a large DTS package that grabs a number of tables from an Oracle DB, does some scrubbing, updates, and...

davisutt

07-27-2007 11:42 PM
dan.rei1@verizon.net

I am trying to justify using SSIS for a small warehouse project in lieu of the company standard Powermart, which I have no experience with. Can...

=?Utf-8?B?S2l0ZW51dERhdmU=?=

07-27-2007 01:56 PM
=?Utf-8?B?S2l0ZW51dERhdmU=?=

Hi All! I need to copy data from DBF file into SQL table by DTS. Some of the rows are corrupt. I would like to copy data row by row, if exception...

Dmitri Todorov

07-27-2007 11:05 AM
Dmitri Todorov

In SSIS, what toolboox item can I use to pull the disinct rows from a flat file that has repeating data. I am trying to do this without importing...

=?Utf-8?B?QnJldHRWUA==?=

07-26-2007 07:51 PM
Paul Shapiro

I'm Using a VB Script (ActiveX Script Task) to create a connection and a recordset to a specific database in the local server. I dont want to name...

Geri Reshef

07-26-2007 08:55 AM
Geri Reshef

Hi, I think I may have mis-guided some of you in my previous post. So I thought I explain it properly this time in a new post... Here is the...

=?Utf-8?B?ZmFyc2hhZA==?=

07-26-2007 08:34 AM
=?Utf-8?B?ZmFyc2hhZA==?=

Hello everyone. I have a package in DTS that I am tryinig to work with. We have a few queries that will export the same exact table to a text...

ic0n67@gmail.com

07-26-2007 08:15 AM
Icon

Hi, I am using a foreach loop to go through the .txt files inside a folder. Using a variable I can pickup the filenames the loop is going through. At...

=?Utf-8?B?ZmFyc2hhZA==?=

07-26-2007 06:10 AM
=?Utf-8?B?ZmFyc2hhZA==?=

Hello I am trying to create a multi-threaded host application which will execute the same ssis package a number of times simultaneously...

thecolour

07-26-2007 04:12 AM
thecolour

Hello Vasanth, You may want to plug in Event handlers for the DTS events and see what comes back. It sounds though like this could be a permissions...

Allan Mitchell

07-25-2007 11:31 PM
Vasanth

I've got a project to export data from a SQL Server and get it into a text file which has multiple records. Basically, the output file has a...

Woodberg

07-25-2007 07:52 PM
Den

Background of the problem I am encounting: In a SQL 2000 DTS package, I created a ActiveX script task with the following code (simplified version). ...

=?Utf-8?B?Ulc=?=

07-25-2007 03:20 PM
=?Utf-8?B?Ulc=?=

Hi all, I am new to this forum. I have a question on DTS packages. I am trying to create a DTS package which loads the data in...

krishraj19@gmail.com

07-25-2007 01:12 PM
krishraj19@gmail.com

I have a flat file feeding a table via a data pump. The table is only used by this process. It will run for about 30minutes and then fail. The...

adayers@hughes.net

07-25-2007 10:25 AM
adayers@hughes.net

Hello, I have a Pipe ('|') delimited Flat File having Nested records into it. Can I handle i.e. pull data from such files into SQL Server using...

=?Utf-8?B?U2FjaGluIENoYXZhbg==?=

07-25-2007 06:51 AM
Allan Mitchell

Hello, I am having a bit of trouble with SSIS Configurations. - In BIDS, I have added a configuration file and specified the properties I want to...

=?Utf-8?B?bWdhbGUx?=

07-25-2007 06:48 AM
Allan Mitchell

Hello, Currently we are a SQL-Server 2005 Standard Edition SP2 (build 3042) and wish to copy a datebase using the Copy Database Wizard....

Ulyssit GmbH - Peter Guenther

07-25-2007 04:09 AM
Ulyssit GmbH - Zane Rickard

In a posting from December, a poster named Dave, issued the following query: The system would not let me post a reply, but I just spent the...

zarnie

07-24-2007 04:09 PM
zarnie

hi, how can i get into the package the user.variable i passed by the command line : DTEXEC /SQL "\aaa\packages" /SERVER SQL2005SERVER ...

=?Utf-8?B?RGFuaWVsIFZha2ls?=

07-24-2007 03:27 PM
Paul Ibison

I have posted this two times before. Now I have SQL server 2005 with Service pack 2. The problem is: I get intermittent problem either when I am...

=?Utf-8?B?R0U=?=

07-24-2007 03:06 PM
=?Utf-8?B?R0U=?=

Version: SQL 2000 DTS I have 13 connections all doing data transformations into one destination connection. The 13 DBs are located throughout the US...

dfleshman@gmail.com

07-24-2007 11:34 AM
dfleshman@gmail.com