Viewing 15 posts - 1 through 15 (of 49 total)
You can use below table script and can insert any test value for test
cREATE TABLE TAB1
(
URN bigint,
eno varchar(MAX),
Schoolname varchar(MAX),
phase varchar(MAX),
)
cREATE TABLE TAB2
(
December 15, 2017 at 6:10 am
Please suggest the way by which I can get the solution
January 5, 2016 at 9:43 am
Sorry for that
Hope you understand the issue.
I want to pass the filtr value in conditional split by variable so that in future if I want to add...
January 5, 2016 at 9:23 am
By changing the scale value of column data coming correctly
Thanks
November 17, 2015 at 12:31 am
Ok,
Can I get the error line number in my error output file.
Regards,
Vipin
October 14, 2015 at 5:03 am
Hi Used below query to get the desired output.
;with cte AS (SELECT [ProgramId]
,[ProgramVersionId]
,[WRINPrefix]
...
September 24, 2015 at 5:24 am
I created 1 variabel with string data type.
and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting
September 1, 2015 at 1:31 am
Actually I want to pass the connection string from outside.
I have same package which will run for multiple location
i have 2 parameter 1 for constring and another for password
How to...
August 14, 2015 at 4:37 am
Hi ,
Yes it exist and I am able to connect using SSMS.
I have below permission on SSISDB Catalog folder
1. Read
2. Modify
3. Manage Permissions
4. Create Objects
5. Modify Objects
6. Execute Objects
7. Read Objects
8. Manage Object Permissions
But also I am not...
August 11, 2015 at 4:06 am
It is working properly when removing Transaction setting from container.
August 10, 2015 at 3:59 am
Hi When I am trying to execute below command I am getting error
BULK INSERT ##MD_GEOGRAPHYLEVELTYPE
FROM 'H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt'
WITH ( FIELDTERMINATOR =',', FIRSTROW = 9 )
error
Msg 4861, Level 16, State 1, Line...
August 5, 2015 at 12:45 am
Do you have similar example of ssis packages
July 30, 2015 at 5:55 am
Hi Becouse As I explained earlier I am having 2 source connection for US .
Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.
For each loop...
July 30, 2015 at 5:35 am
Viewing 15 posts - 1 through 15 (of 49 total)