Viewing 15 posts - 1 through 15 (of 25 total)
I got it.. I was setting checkpoint on the job which failed. When it failed I renamed the file name and tried to re-run the packgae. Because in Checkpint.xml file...
June 16, 2010 at 12:03 pm
Here you are using Lookup Cascading Pattern. Please make sure the following:
1. First Lookup -- Setup the cache property to FULL Cache. This will have 2 outputs for you. 1...
June 16, 2010 at 9:25 am
I have faced this issue while copying it to production environment. I explicitly delete the previous package and then copy the new package manually.
June 14, 2010 at 5:39 am
I got the same problem initially in Bids 2005
Type in Microsoft.VisualBasic.Constants.
where you press"." you will see two options in intelli sense window
"Common" and "All"
In all I was not...
June 10, 2010 at 9:52 am
In you Data Task create Excel Source
there select Excel Connection Manager and map to the excel file. Since you have read only permission you can extract complete data.
June 9, 2010 at 5:28 pm
Can you post some same data of txt file and the table.
June 9, 2010 at 3:48 pm
here you go
(DT_WSTR, 30) (DT_DATE) GETDATE()
Output:
6/9/2010 4:53:30 PM
Desired Format: MM/DD/YYYY HH:MM:SS AM/PM
June 9, 2010 at 2:54 pm
I was able to run this query and it worked. To view the value of the variable use the Quick Watch window. This appears when the debugger is stopped...
June 9, 2010 at 2:36 pm
Hi
Yes you can do that. There are two scenarios
1. There is only 1 file in the folder at a specific time
Please follow my posting
http://qa.sqlservercentral.com/Forums/Topic933534-148-1.aspx
2. If...
June 8, 2010 at 2:12 pm
I dont think CLR could be used here as an approach. Though it is one of the options.
1. The enviornment currently used in legacy system where ASP and Sql server...
June 7, 2010 at 6:38 pm
Please follow the following steps:
1. Get data from the database using the ASP code
2. REmove the HTML tags from the Data retrieved
June 7, 2010 at 2:26 pm
how about this
1. Use WMI Task to get latest file based on the time stamp
2. use a Data flow task to perform the operation
In case you need to process multiple...
June 7, 2010 at 9:56 am
Hi Jyoti
Please follow the following steps :
1. Click on package properties. Set "DelayValidation" property to True.
The package will not validate tasks, connections, until they are executed.
2. Create an Excel...
June 7, 2010 at 9:41 am
You can use WMI Task for the same.
June 7, 2010 at 5:09 am
Your same data doesnt look good.
Can you send some actual data to look into
June 7, 2010 at 4:54 am
Viewing 15 posts - 1 through 15 (of 25 total)