Viewing 15 posts - 166 through 180 (of 203 total)
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain
Inherits UserComponent
Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
...
May 29, 2008 at 1:25 pm
Kbattta, I don't agree with u . that might be a solution, but what if u load file daily and ur load is automatic. u don't want to open each...
May 28, 2008 at 9:38 pm
Samtel.. , u sound mad and frasutrated. Common this is not the place to show, and my appologies if i am wrong.
What i understand is--u have a flat file and...
May 28, 2008 at 3:43 pm
Dear Pu.........,
My assumption was not a statement, it was a question becoz i was failing. Finally with some tweaks i was able to do it. There was nothing wrong...
May 23, 2008 at 8:03 am
SORRY.......
Here is the code---------
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim fso
Dim fil
Dim fold
Dim coll
Dim CurrentDate
Dim i
Dim arrFiles()
Dim pkg
Dim stpContinue
Dim stpStop
set fso = CREATEOBJECT("Scripting.FileSystemObject")
set fold = fso.GetFolder(DTSGlobalVariables("FilePathRoot").Value)
set coll = fold.files
CurrentDate...
May 15, 2008 at 2:20 pm
HEllo, I am doing Migration Too. never had problem of these type. However, there are some task that will never get migrated, so bettr is skip and run the wizard....
May 15, 2008 at 9:45 am
Thanks Michael , I will try your first option tomorrow.
I think i am not clear in explaning my problem. I want to send email as weel as log the problem...
April 29, 2008 at 9:12 pm
Yes Throws me error, becoz those empty strings gets truncated and sql server thinks some data are being lost. tried every possible cobinations that I could think of
April 23, 2008 at 7:29 am
When u click the propert expression square eclipse on the right, an expression builder opens, where u can bulid the expression and also u can evaluate it before u press...
April 21, 2008 at 12:49 pm
I am not sure exactly i understood everything here.
But, few days back i used to have the same problem with null columns that was a dbtimestamp. My case was i...
April 18, 2008 at 7:43 am
Thanks Prarav!!!! Aprreciate ur time and response. let me try here . U r right, u don't learn until u make mistakes. i will update the progress. Once agian thanks.
April 16, 2008 at 12:01 pm
One option I can think of is redirect error to flat file. Just use dataviewers to see how the bad rows gets directed.
Thanks.,
April 16, 2008 at 9:50 am
I understood this part. The problem, or i would say my confusion is , ok, i have 30 bulk insert connections, and every bulk insert connectiosn uses different files, however...
April 16, 2008 at 9:41 am
Thanks Pravar!!! What i did was something little different. I have like 50+ packages. All together there are 6 databases that i will be connected to. SO for eack database...
April 16, 2008 at 9:23 am
Pravar YOu are absolutely right!!!!! If u are using XML file and reuse same file for other packages then u have to have same connections for all other packages ....
April 15, 2008 at 2:23 pm
Viewing 15 posts - 166 through 180 (of 203 total)