|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 SLOwly Changing Dimension Object Posted by alexde at 9/14/2006 1:06:02 PM any simple example on internet with SCD SSIS object?
building an example I am getting and error:
there must be at least one column of fixed, changing or historical type of
input for slowly changing dimension transform
help appreciated.
thnx,
Alex...more >>
Can't change authentication when connecting to SSIS Posted by Ferg at 9/14/2006 8:59:00 AM I am trying to register a server under SSIS and the dialog box has NT
authentication and is greyed out so that I can not change it to th sa
account. When I try an connect, I get access denied. Anyone have any
clue as to what is going on?
...more >>
SQL task result set with Nulls -- how to assign to variable? Posted by artzoop NO[at]SPAM hotmail.com at 9/14/2006 8:22:27 AM Hi,
I have an SQL task that returns 3 columns from a select statement (eg,
Select a, b, c from tableabc). I assign my result set result names 0,
1, 2 to three User global variables (which happen to be type string).
All works fine as long as a, b, c contain values on the tableabc. If
any colum...more >>
Eveng Log messages Posted by Radim Hampel at 9/14/2006 5:04:02 AM Hello all,
I run my packages using SQL Agent. Any time a package is run I have two
records in event log: "Package <package name> started." and "Package <package
name> finished successfully." Event IDs are 12288 and 12289, source is
SQLISPackage.
How could I disable this logging option? S...more >>
SSIS Pkgs Posted by Ferg at 9/13/2006 2:01:49 PM I am new to 2005 and am in the process of moving a developers pkg to
the server and scheduling it. I got it moved and scheduled the pkg but
it did not execute. Where do I go to see the pkg and execute myself vs
the scheduler
...more >>
Need help with copy database Posted by moondaddy at 9/12/2006 11:04:19 PM I need to be able to copy a database to a new database. yes I know I can
use backup and restore or detach-attach so please don't recommend those. I
have a db which was a sql 2k db and I attached it into sql 2005. then I ran
maintenance plans on it to clean it up. Now I want to copy it to a...more >>
VBScript in SQL 2000 for a DTS Pkg Posted by Chris at 9/12/2006 7:35:02 AM I need to create a vbscript in a DTS pkg that takes the results of a query
and exports the data to a spreadsheet but exports data on different sheets
with in the workbook according a group.
In short I want to group the data then export it to a different sheet with
in the same workbook.
...more >>
Error While saving a DTS Package Posted by Ullas at 9/11/2006 10:53:38 PM Hi,
When a try to save a DTS Package, i get following error message.
Could not find stored procedure 'master.dbo.xp_sw_version'.
The statement has been terminated.
Anybody has any idea on this... Please help!!!!.
Ullas. K.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Teradata question Posted by Umar at 9/11/2006 1:26:02 PM I am trying to issue an INSERT statement from within DTS to Teradata. I want
to use "Parameters" as value in the statement. While doing this in Oracle it
was easy, I was passing question mark "?" in the VALUES.
Don't know how to do that with Teradata. Please help....more >>
Foreign Key constraint violation when exporting to local server Posted by Velvet at 9/11/2006 12:24:59 PM I would like to give my client the ability to make backups of their live SQL
Server 2000, but when I export using the export wizard, I get a foreign key
error on foreign keys where they should have a WITH NOCHECK in them because
a null or zero value is allowed in that particular field and does...more >>
Adding a new Column to a SSIS Package from a Flat Text File. Posted by Midway at 9/11/2006 10:29:02 AM Hi there,
I want to know if this is possible in a SSIS Package. I am importing some
Flat Text File to a table, but I would like to add a column to the package,
and I am able to do this, but I would like to have some specific data in the
new column added for each row in the flat file. is th...more >>
DTS transformation from flat file Posted by Kalyan at 9/11/2006 7:58:03 AM hi
I wanted to know, is this possible?
I am transforming about 1 miilion rows from text file into SQL Table, There
is one column is integer, There are some changes to have alphanumeric in flat
file.
while inserting this column into interger column in table dts will fail, In
Informatica...more >>
Problem importing special characters from text file Posted by hursting at 9/11/2006 6:00:11 AM Hi,
I have a dts package that works correctly apart from one issue. I
have a number of items to import that have fench names. The special
characters in the names get translated into something different. I set
the autotranslate option to false on the connection objects but this
didn't help. I...more >>
Deploy SSIS to Sub-Folder in MSDB Posted by Norbert Kessler at 9/11/2006 4:06:02 AM Hello,
we created a sub-folder structure within the msdb storage. Is there any
possibility to explain in the DTSDeploymentManifest or wherever that the
packages should deployed into a specific subfolder and not to the root?
thanks in advance
Norbert...more >>
How can I import a file through HTTP connection in DTS or SSIS? Posted by Alcibiades NO[at]SPAM gmail.com at 9/11/2006 3:06:00 AM I tried DTS and SSIS both. But it seems there's no way to import data
from a web page.
Basically, my client has a php page on their server. I can access the
file by using an URL (for example http://myclient/page.php?id=56). And
this will return a XML file.
in SSIS, i can easily import a XML f...more >>
How i can excute different package (Child) using script task in parent package. Posted by anoopagrwl NO[at]SPAM gmail.com at 9/10/2006 11:39:58 PM Hello,
i have a problem. i want upload data from .txt file. these files reside
in a folder and i want to upload the data from these file to sql
servers different tables using SSIS.
1. should i use Foreach loop container & using script task in Foreach
Loop container. in which (script) i have to ...more >>
How do I obtain a FlatFileColumn object? Posted by Amnon at 9/10/2006 7:02:47 PM Hello all
I am writing a custom flat file pipeline source component, and would like
to reference an existing flat connection and use its columns definition.
I could get a reference to my ConnectionManager object -
myFlateFileConnection and trying to get its coulmns through:
IDTSConnect...more >>
dts import with utf-8? Posted by Fotis Mylonas at 9/8/2006 3:49:04 PM Hallo all,
we have some dts packages on a production sql server, used for to import
text data. My country is Greece so a lot of greek characters are included in
the txt sources.
The organization providing the txts to our application, used to have them in
unicode format (2 bytes per character...more >>
Trying to import data from Access, being stung by "missing workgroup information file"! Posted by 0to60 at 9/8/2006 10:16:54 AM I'm using Management Studio's Tasks->Import data tool to try to import data
from a MS Access database .mdb file. But, I keep getting the "the workgroup
information file is missing or opened exclusively by another user" error
message. No, this file isn't open anywhere else. Yes, I have syste...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |