Hi,
I was wondering if anyone know how to do Dynamic Properties Tasks in SSIS? And, does anyone know how to create a global database in SSIS so I won't have to change all of the database names in my package? I'm sorry, I'm new to SSIS and I'm just really frustrated. Thank you.
Hi all,Can you please share some interview questions that can be expected on SSIS 2005?
View 8 Replies View RelatedI am using SAS Dataset and loading in to SQL server 2005.Now i want to delete columns which have 0 values and null values.Can anyone guide me how to do this?thank you.
View 3 Replies View RelatedHello,
I realize that I am confused about SSIS and security.
In BIDS, I work on and modify my packages. That part I understand. Then, I want to build my project, then deploy to SQL Server 2005. I know how to do that too (for the most part, please see below):
My confusion arises around the "Protection Level" options in the package properties. Right now I have everything set to "EncryptSensitiveWithUserKey". My understanding is that I need to change this in order to run my packages from SQL Server jobs, because only the creator of the package can currently run the job.
So my question is, since I want to deploy to SQL Server, don't I want to change the "Protection Level" to "ServerStorage"?
However, it will not let me change the protection level to ServerStorage. It says "The protection level, ServerStorage, cannot be used when saving to this destination"... presumably because it is attempting to save to the file system.
However, even when I built out my packages and saved to SQL Server, I could not change the protection level either.
Which is why I am really confused... Once you save your packages to SQL Server, how do you make changes to the packages, so that the changes are reflected in the packages stored on SQL Server?
There is some concept I am not understanding here.
Thanks for any help
I have some questions on SSIS tool I tried to read many docs to understand SSIS.
Now I am looking forward for below questions.
How to use SSIS for :
1. How to Export data from SQL Server 2005 in to Access database using SSIS?
2. How to Import data from Access .mdb file to SQL Server 2005 database using SSIS?
3. How to Import Oracle10g data in to SQL Server 2005 databvase using SSIS?
4. How to Import Oracle10g Data to Access file using SSIS?
5. How to Import SQL Server 2000 data in to SQL Server 2005?
It will be great to have step by step explanation.
Thanks in advance.
Please write YES/NO against point number in your answer i.e. for example:
1) YES, 2) YES, 3) NO, 4) YES etc.
We have source SQL Server 200 databases in one instance and target SQL Server 2005 in another instance both being on different windows 2000 server systems.
Target OLAP DB design is derived from source OLTP.
Most master & transaction tables are as is but some target tables are a result of merging source tables.
We need to do SSIS packages based migration using data flow task based on column mapping & queries using Business Intelligence Development Studio (BIDS). There are no transformations required.
1) Can I group packages under project into sub-groups i.e. super packages?
2) Can I execute a set of packages together which are logically/physically grouped?
3) Can we execute set of ordered packages/individual packages from command line and even
stored procedure?
4) Can we maintain transaction integrity across the entire set of ordered packages we execute?
5) Can we send a mail to mail id(s) in case of events like OnError etc.
6) Can we schedule the packages?
7) Does SSIS provide via BIDS a way to compare data in source with target to decide what got
inserted/deleted/updated and based on that do the necessary?
8) Can SSIS packages be developed including code for data encryption?
9) Can we pass parameters to packages that get called from stored procedure?
10) Can we call stored procedure/function in SSIS package?
0) We are migrating data from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design.
1) We have an data flow task SSIS package.
2) We managed to send a mail with various variables & their values in subject or body of mail.
3) How do we send mail with details of Error/Warning using OnError/OnWarning events?
4) Can we have bad tables i.e where records which failed to migrate get inserted into. If yes, what are the steps to implement this.
5) Can we have a mix of in-built & custom logging. Is logging provider necessary to do logging. What logging provider to use?
6) Where are the errors that come during build, deploy, install and execute stored? Is there a log file(s) & what it their location?
7) Please post links if that is better.
I have been working with SSIS and find myself stopped on what seem like very basic tasks.
Am I right in thinking that, if you want to import a flat file into a SQL datatable, in most PC based systems, that you have to manually cast EVERY SINGLE COLUMN to unicode string, if you don't want to get the 'cannot convert between unicode and non-unicode string data types'? I mean, this is surely a VERY COMMON task, taking a CR/LF delimited ASCII file and dumping it into a database tables? What if you have 50 fields to import?
Am I the only one who finds it very difficult to cast a string from a textfile to a date format? At this point, I always just dump the date to a 8 character string and save it that way, and use a SQL view to cast it to a date. At least SQL Server can do 'basic date conversions'. Is there any way to freeze execution and find out what data was provided to a derived column, if you're trying to do some substring operations and hodge together a date? I couldn't find any. I usually put a extra column in a datatable and plunk some data there to find out 'what it looked like', how else can you debug an SSIS program?
Is there a planned service pack or update to SSIS that will make this more usable? Does Microsoft ever intend to implement an UPSERT type module? Or a File Move operation that handles directories that fill up with log files, each of which have to be added to a datatable and then moved to an archive directory (surely, another very common task - I figured out how to accomplish this but it is far from intuitive, the way it currently works). Sorry for grumbling, but honestly, I find turnaround time to develop a very simple import program is RIDICULOUS. It's quicker to write a COBOL program to issue a bunch of formatted SQL UPDATE statements than using this application.
Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions.
Thanks
I am using SSIS with Transaction, and I met a lot of questions as below:
1.IF DTC doesn't support ADO.NET Connection?
Please check the ADO.net Connection's property, it has a property named like: DTCTrancactionSupport. But it's always set to False and unable to edit.
IF the answer is NO, HOW could I bound all my Tasks into one Transaction? You know, I have some Tasks with SQL connection, and I have also some Script Tasks, witch need the ADO.net connection.
2.IF DTC required to run in both the Destination Server and the Source Server?
I have a Dataflow Task, and take some data from a table in a Source Server to a Destination Server. The DTC doesn't run on the Source Server. I found the Dataflow Task hangs when I use the SSIS Transaction(just set the Task's transactionOpion to Required, Only one Task in the Package).
3.IF DTC doesn't support RetainSameConnection?
Many people say that. Really?
4.When a DTC transaction is running, if the table in it could not be modified by process outside of the transaction? For example, a package with a DTC transaction, and there is a SQL Task inside, when it is running, could I modified the same table's data manually(in the Sql Sever Management Studio)?
Hello all, this is my first post, I have a couple of basic questions regarding the use of SSIS. I have used SSIS for a couple of years for on off table loads but never implemented production jobs with it so please bear with these questions.
1. When making scripts that connect to one or more databases, is there a way to store the userid and password somewhere besides embedded within the package, such as a web.config file, this would make routine password changes much more manageble.
I guess it was only one question but any help would be greatly appreciated.
Thanks.
I have a question regarding a DTS (SQL server 2000 package) to SSIS (SQL SERVER 2005 package) migration.
which is the best forum to post my question ?
I have a some raw data in a string that looks like
'1989'
I need that to become numeric 19.89
if I define a type double for rawAmount
and do this:
rawAmount = CInt(iRest.Substring(41, 4))
Row.amount2 = rawAmount / 100
where row.amount2 is a type double precision float from my script component task output, I get:
19.899999999999999
what output should i use in this data flow component to get 19.89.
thanks.
The following is a list of questions that I have not been able to obtain concrete answers. I am probably missing something:
1) ReadWriteVariables -- can the updated value for a ReadWriteVariable be accessed within the same data flow? It appears not as I think the PostExecute() fires at the completion of the data flow not the end of the Script Component. Secondarily, the Script Component is a non-blocking transformation so the component does not "see" the end of the pipeline prior to sending data down stream.
2) Record Count -- Because of #1 above, How could you calculate a record count for a data stream? It does not appear that one can calculate the number of records for a data stream within a data flow and then access the count from within the same data flow.
3) FinishOutputs() -- Is the concept of FinishOutputs() applicable to Script Component Destinations? Asked another way, is FinishOutputs() executed at the end of the data stream regardless of whether there are "real" outputs for the component? I can create a "Dummy" output to create FinishOutputs() but is this ok?
4) Script Component -- It appears that the Script Component Source, Transformation or Destination are really defined based on the columns defined in "Inputs and Outputs". Can you convert an Source script component to a transformation script component by simply adding an Output?
Sorry for these basic questions but I am not getting it completely. As you can tell...
Guys,
I got this error while I try to migrate one of my dts packages from dts to ssis. Where do I start from?
The package is got 4 separate vb active x scripts in it and it is also calling four other packages. The package run successfully when I migrated from SQL 2000 DTS to SQL 2005 legacy DTS using 2000 runtime. But the problem is when I attempted to to migrate to SSIS using the package migration tool in sql server 2005.
The problem is I am a DBA but never have to create a DTS or SSIS from the scratch before...
Regards,
LogID=1
#Time=11:11
#Level=DTSMW_LOGLEVEL_WARN
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Not all the connections from SQL Server 2000 are migrated to the main SQL Server 2005 package. For example, Text (Source) and Text (Destination) are not migrated to the main package.
LogID=2
#Time=11:11
#Level=DTSMW_LOGLEVEL_WARN
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Not all tasks from SQL Server 2000 and SQL Server 7.0 are migrated to SQL Server 2005. For example, the migration of the Analysis Services Processing task and the Data Mining Prediction task is not supported.
LogID=3
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Finished migrating connections for package: Pub Extract Search Data
LogID=4
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSDynamicPropertiesTask task migration for package: Pub Extract Search Data
LogID=5
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSDynamicPropertiesTask task migration for package: Pub Extract Search Data
LogID=6
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=7
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=8
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=9
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=10
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=11
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=12
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=13
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data
LogID=14
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=15
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=16
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=17
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=18
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=19
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=20
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=21
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data
LogID=22
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Finished migrating tasks for package: Pub Extract Search Data
LogID=23
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Finished migrating variables for the package: Pub Extract Search Data
LogID=24
#Time=11:11
#Level=DTSMW_LOGLEVEL_MSG
#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework
#Message=Successfully saved the package "Pub Extract Search Data" in the destination "ITEM-40561SQL_2005Pub Extract Search Data".
I am very new to SSIS though I have written hundreds of SQL 2000 dts' with all kinds of active scripts doing all kinds of things. I am now trying to convert them to SSIS and since scripts don't come through the migrator I am doing them by hand once again. I have the package created, but one of the input fields on the text file is YYYYMMDD , but the database field it is going into is a datetime so I need to convert it to a valid date format so that the conversion will take place. I tried data conversion task but that doesn't work, now I'm assuming I need to use the derived column, but not sure and don't have a clue how to use that, can anyone help? Thanks bostonrose
View 2 Replies View RelatedHi
I have created a package which imports a unit of measure table. I now want to populate more rows in the same table from itself. In Access VBA the below code extract does the first part of the job I need to do. Can anyone point me in the right direction to convert this into an efficient SSIS solution.
SQLstr =€?SELECT [UOM conv].[Short Item No], [UOM conv].UOM, Count([UOM conv].[UOM 2]) AS [CountOfUOM 2] €ś & _
€śFROM [UOM conv] €ś & _
€śGROUP BY [UOM conv].[Short Item No], [UOM conv].UOM €ś & _
€śHAVING (((Count([UOM conv].[UOM 2]))>1)); €ś
Set RsMoreThanOne = db.OpenRecordset(SQLstr)
With RsMoreThanOne
While Not .EOF
SQLstr = "SELECT [UOM conv].* FROM [UOM conv] WHERE ((([UOM conv].[Short Item No])=" & ![Short item No] & ") AND (([UOM conv].UOM)='" & !UOM & "'));"
Set RsSql = db.OpenRecordset(SQLstr, dbOpenSnapshot)
RsSql.MoveLast
x = RsSql.RecordCount
Set rs = db.OpenRecordset("UOM Conv")
rs.Index = "PrimaryKey"
RsSql.MoveFirst
Item = RsSql![Short item No]
For y = 1 To x
Um1(y) = RsSql![UOM]
Um2(y) = RsSql![uom 2]
Fct(y) = RsSql!factor
RsSql.MoveNext
Next y
For y = 1 To x - 1
For k = 1+y To x
rs.Seek "=", Item, Um2(y), Um2(k)
If rs.NoMatch Then
rs.AddNew
rs![Short item No] = Item
rs!UOM = Um2(y)
rs![uom 2] = Um2(k)
rs!factor = Fct(k) / Fct(y)
rs!calculated = True
rs.Update
Else
If rs!calculated = True Then
rs.Edit
rs!factor = Fct(k) / Fct(y)
rs.Update
End If
End If
rs.Seek "=", Item, Um2(k), Um2(y)
If rs.NoMatch Then
rs.AddNew
rs![Short item No] = Item
rs!UOM = Um2(k)
rs![uom 2] = Um2(y)
rs!factor = Fct(y) / Fct(k)
rs!calculated = True
rs.Update
Else
If rs!calculated = True Then
rs.Edit
rs!factor = Fct(y) / Fct(k)
rs.Update
End If
End If
Next k
Next y
RsSql.Close
.MoveNext
rs.Close
Wend
.Close
End With
db.Close
Regards
ADG
I'm editing an SSIS package. The source column has datatype float and the data is stored like 1,2 instead of 1.2. To change this into a period instead of comma there is a derived column step in the ssis package. The expression in this derived column step to change this goes as:<o:p></o:p> (DT_STR ,32,1 252)(REPLACE((DT_STR,32,1252)SUBSCHAAL_SCORE,",","."))<o:p></o:p>
where SUBSCHAAL_SCORE is the name of the column. As you see the data is converted into a string. I need it to be converted into a numeric datatype (18,6) instead of string/varchar but it must also handle the first issue with changing the comma into a period. <o:p></o:p>
I am using OLE DB source to extract data from Oracle. I have query (sample) like below, but SSIS is converting ID as Unicode String [DT_WSTR]. Why is that? and how to avoid this?
SELECT
1 AS ID
FROMÂ
ORACLE_TABLE
I have a SSIS package which is reading from an Excel file.Â
The Excel is created from a report from another system and sometimes the date of birth formats as a Date and sometimes as string.
I've added a data viewer so I can see how the columns are read as soon as SSIS reads the file.Â
When the cell in Excel is set as text its read correctly - I can then convert to a date as necessary
When the cell in Excel is set as date its read in US format! i.e. if it was 01/13/2014 in excel its read as 13/01/2014
How can I get round this? Its not an option to manually force the column to be text once exported from the system as my package picks this up automatically.
I have triedÂ
-Regedit set typeguessrows = 0
-IMEX = 1 in connection string
-Set LocaleID = UK in the data flow task to read from Excel
Hi, how do I convert dates with SSIS, when I receive dates I have no problem, with empty fields I have to go through a transformation as:
trim(field_name) == "" ? "999999" : substring....... (derive transform)
after this I have to update each field holding '999999' to NULL. (using sql task)
Is there an easier way to doing this?
Thanks
I am trying to convert a string variable to integer in SSIS using the expression task.
@[User::Nummer] = (DT_I4) @[User::Name]
But I get an error that the conversion from (DT_WSTR) to (DT_I4) is not possible!!
I am getting below errors when I try to import data from csv format to a sqlserver table.The csv file has date column that has date with format: 7/10/2015 Â 1:18:39 PM and the sql server is using datetime not null for that field in the table.
[OLE DB Destination [90]] Error: SSIS Error Code DTS_E_OLEDBERROR. Â An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Â Source: "Microsoft SQL Server Native Client 10.0" Â Hresult: 0x80004005 Â Description: "Invalid date format".
[OLE DB Destination [90]] Error: There was an error with input column "Date" (138) on input "OLE DB Destination Input" (103). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
I have flat file source from which data is imported to a Sql table.The target column is int and input column is string .The column has some numeric values and some blank values.when I tried to convert into int values it fails.
View 7 Replies View RelatedIn my package , I am used CDC Source transformation and received the Net changes then insert into Destination. But whatever Data coming from CDC source data type Varchar value needs to Converting Non Unicode string to Unicode string SSIS. So used Data conversion transformation to achieved this.  I need to achieve this without data conversion.
View 3 Replies View RelatedI have an ssis package that downloads a SQL Server 2000 database and restores it to a SQL 2005 server. Ninety-five percent of the time it runs just fine, but every so often the job fails and I get the following set of error messages in the log file. (I have had to delete some of the proprietary information for this message to satisfy my boss like putting in [Database name] in place of the actual name of the database in the error message).
OnError, Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611.
OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551.
OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name].
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name].
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name]
FROM DISK = '[Path to back up file]' WITH REPLACE,
MOVE 'ASP_Live_Data' TO [Path to MDF file],
MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name]
FROM DISK = '[Path to backup file]' WITH REPLACE,
MOVE 'ASP_Live_Data' TO [Path to MDF file]',
MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
OnTaskFailed,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,(null)
Does anyone have any suggestions?
1. Is it legal and OK to use a MSDN SQL copy on a production environment or is it strickly for test environments ??
2. If I own a legal copy of SQL 7 with 5 cals, can I legally use SQL MSDE and have more than 5 people access my SQL server or am I also limited to 5 users as my original ??
Sorry I am a newbie at this SQL thing.
We have some columns in a table where the date is stored as 19980101 (YYYYMMDD). The data type for this column is NUMBER(8) in Oracle.
I need to copy rows from Oracle to SQL Server using SSIS. I used the Data Conversion transformation editor to change it to DT_DATE, but the rows are not being inserted to the destination.
On Error, If I fail the component, then the error is :
There was an error with input column "ORDER_DATE_CONV" (1191) on input "OLE DB Destination Input" (29). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
Regards
RH
I have some tasks that I need to accomplish within T-SQL but cannot find
a means to accomplish them.
They are..
1. Check for the existance of an external text file.
2. Count the number of rows in an external text file.
3. Be able to run the BCP command from within T-SQL. I am currently using
the BULK INSERT command which works fine but it does not allow the following..
a. Error log for failed inserts.
b. A command output file.
Any information would be greatly appreciated.
Jim
I am tying to call BCP to output the contents of a table to a text file from with in a stored procedure.
The procedure will be called from an ASP page ...
My question is were does the file get created ??? I want to create the text file on server ONE and SQL server is running on server TWO and IIS is running on server THREE... do i have to have a drive letter mapped to server ONE and if so is it mapped on the SQl server or the IIS server ....
ie:
exec master..xp_cmdshell bcp db..table out h:est.out -Uxx -Pxx -Sx
thanks for any help on this subject ...
Rob
I have some tasks that I need to accomplish within T-SQL but cannot find
a means to accomplish them.
They are..
1. Check for the existance of an external text file.
2. Count the number of rows in an external text file.
3. Be able to run the BCP command from within T-SQL. I am currently using
the BULK INSERT command which works fine but it does not allow the following..
a. Error log for failed inserts.
b. A command output file.
Any information would be greatly appreciated.
Jim
I have two questions,
1) Could anyone please point me in the right direction concerning information pertaining to NT Server Enterprise Edition verses NT Server Workstations. We are having problems running SQL Server 7.0 and the Enterprise Edition together on the same machine and was wanting to find information about compatability issues, if there are any,
2) I, on a SQL Server 6.5 database shrunk it by 2 Gb. When I looked to see if SQL Server released those 2 Gb back to the hard drive, I was amazed that it didn't! Did I miss something or will SQL Server 6.5 not release the space because of the initial set-up. And why did SQL Server 6.5 automatically take the space from the Transaction logs when neither of the devices were specified? Is the Transaction Log the default area for shrinkage?
Thanks in Advance!
Daimon Russell
daimon_r@hotmail.com
Hi, does anyone know how to explain how SQL transactions get mapped into TDS and TDS gets mapped into TCP/IP packets?
Or can you please point me in the right direction? I need to figure out how TDS and TCP/IP relate?
We're using replication and are having some latency issues and I'm trying to find out how SQL handles TDS and TCP/IP etc...
Thanks for your time.