How to access open Flatfile
Thu, 26 Jun 2008 11:56:17 +0200
Hi,
I have a problem accessing an open Textfile. I created a package to
Import Logfiles from an application which creates a new log every hour.
I can access the archived log-files without problems and I can preview
(!) the actual log in the SSIS-Designer, but I get an error that the
acutal Log-File is in ...
|
How can I use DtsGloablavariables value ?
Wed, 25 Jun 2008 16:31:01 -0700
Hi,
I have select statement in my dts package and it returns 2-3 rows for
DtsGlobalVariable.
So I am vbscript stuff to catch that value and use it to create a new
partition for cube.
So example how can move my global variable's value to a variable
newpartition = DtdGlobalVariable("xxx_name").value
doesnt ...
|
NEWBIE - can't run SSIS package in SQL server agent scheduled job?
Wed, 25 Jun 2008 09:55:57 -0700
I have a SSIS package that runs fine in Visual Studio. But if I put it in
a scheduled job in SQL Server agent, it won't run.
Both VS and SA use the same account to run.
The error I get in the logs is an ODBC error.
The package does have an ODBC connection in it.
The connection uses a SYSTEM DSN connect ...
|
unable to pass string from proc to SSIS variable - HELP!!!
Tue, 24 Jun 2008 22:23:57 -0500
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 the
stored proc, every thing is fine, however, it gives me a data type mismatch
error when I declare the variable as varchar in stored proc and as STRING in
SSIS.
...
|
Importing Query From .sql file?
Tue, 24 Jun 2008 06:37:02 -0700
Hi
can u tell me how to fetch query from .sql file while working in DTS 2000?
actually, I need to fetch query from . sql file(on local drive) and then
want to execute this query on a sql database to export that sql data to a
.txt file using dts 2000.......
Hey ...give any comments.........yes, no, ...
|
DTS Runtime Issue Calling DTS Package within another DTS Package
Tue, 24 Jun 2008 06:19:01 -0700
Hi,
We have a fairly complicated set of DTS packages which are run nightly to
perform our ETL process for our reporting environment. In most cases, the
process runs successfully. However, occasionally, the parent package will
trigger multiple instances of one of the packages and we will get a deadlock
o ...
|
Export to excel (Overwrite not append)
Tue, 24 Jun 2008 00:16:01 -0700
I have created a DTS package that exports to an excel file.
The problem I am getting is that this dts package need to runs once a day
and it appends the data each time it runs. I need it to Truncate the Data in
the excel file before copying the new data to it.
Does enyone know how to truncate an Excel file u ...
|
|
|
MS Project 2000 OLE Provider
Mon, 23 Jun 2008 21:12:01 -0700
Has anyone attempted to use DTS to open MS Project 2000 files ? If so; how
did yo succeed at this.
Many thanks
Scotchy ...
|
Transfer related tables in one Dataflow
Mon, 23 Jun 2008 14:57:00 -0700
Hello All,
Is there any way to transfer related tables in one Dataflow? I found a
couple of articles in Internet, but they recommend using 2 dataflows or raw
files. My dataload is within distributed transaction, so it can not be raw
files.
I have following requirement. There are 2 tables related in one-t ...
|
DTS Tasks not there???
Mon, 23 Jun 2008 07:29:00 -0700
Hello All,
I have a problem with a clients station, and don't really know enough about
SQL server.
Here's the issue.
I would attach a screenshot, but can't seem to find that option here...
When the user goes into "Data Transformation services", then into "Meta Data
Services Packages", goes into ...
|
