agarwalashish1989.blogspot.com

Ashish Agarwal

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

http://agarwalashish1989.blogspot.com/

OVERVIEW OF agarwalashish1989.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

15

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR AGARWALASHISH1989.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

August

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.7 out of 5 with 10 reviews

5 star

7

4 star

3

3 star

0

2 star

0

1 star

0

Hey there! Start your review of agarwalashish1989.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

4.5 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT AGARWALASHISH1989.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

15

SSL

EXTERNAL LINKS

0

SITE IP

74.125.239.138

LOAD TIME

4.524 sec

SCORE

6.2

PAGE TITLE

Ashish Agarwal | agarwalashish1989.blogspot.com Reviews

<META> DESCRIPTION

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

<META> KEYWORDS

1 ashish agarwal

2 public

3 main

4 objreader as

5 streamreader dts variables srcdatafile

6 valuetostring

7 sline as

8 string

9 arrtext as

10 arraylist

CONTENT

Page content here

KEYWORDS ON PAGE

ashish agarwal,public,main,objreader as,streamreader dts variables srcdatafile,valuetostring,sline as,string,arrtext as,arraylist,msgbox sline,replace,dtsvariables createsqlcmd,value = sline,cbool,dtsvariables i,value then,value =,objreader close,name

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Ashish Agarwal | agarwalashish1989.blogspot.com Reviews

https://agarwalashish1989.blogspot.com

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

INTERNAL PAGES

agarwalashish1989.blogspot.com

1

Ashish Agarwal: September 2012

http://agarwalashish1989.blogspot.com/2012_09_01_archive.html

Saturday, September 29, 2012. Adding AutoComplete Functionality to a TextBox Control using C#.Net. Today I am writing my first C#.Net Article going a bit out of my way from SQL and MSBI. This is something related to a requirement which comes my way when in a windows Application i need to give a drop down for all like customer names when typing the names in the Text Box as a very basic user friendly option. Here is how we can do this -. SELECT FirstName FROM CustomerTable". Monday, September 17, 2012.

2

Ashish Agarwal: June 2014

http://agarwalashish1989.blogspot.com/2014_06_01_archive.html

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

3

Ashish Agarwal: Deleting Duplicate Data From SQL Server Table

http://agarwalashish1989.blogspot.com/2013/03/deleting-duplicate-data-from-sql-server.html

Monday, March 25, 2013. Deleting Duplicate Data From SQL Server Table. Duplicate data is a very well known and frequently occurring issue in any DBMS and dealing with deletion of duplicate data is something not that easy for one specially one who is dealing with crucial and huge data. There are 2 scenarios which can come while deleting duplicate data -. 1 when we have an identity column in our table containing duplicates. Insert Data into Table with multiple Duplicate entries. Use Below Query -. Declare ...

4

Ashish Agarwal: Use of Script Task to create SQL table using VB.Net in SSIS

http://agarwalashish1989.blogspot.com/2014/06/use-of-script-task-to-create-sql-table.html

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

5

Ashish Agarwal: August 2013

http://agarwalashish1989.blogspot.com/2013_08_01_archive.html

Wednesday, August 14, 2013. Scripting Indexes in SQL 2000. Loop through all indexes. Check if the index is unique. Check if the index is clustered. Get all columns of the index. DECLARE IndexCursorColumn CURSOR FOR. SELECT SC.Name,0,0. FROM dbo.sysindexkeys IC. JOIN dbo.syscolumns SC ON IC.ID = SC.ID AND IC.Column ID = SC.Column ID. WHERE IC.ID = @IxTableID AND indid = @IxID. ORDER BY IC.Index Column ID- ,IC.is included column. Indid - ,IC.is included column. Check to see if it's an included column.

UPGRADE TO PREMIUM TO VIEW 10 MORE

TOTAL PAGES IN THIS WEBSITE

15

OTHER SITES

agarwalaroma.wordpress.com

Aroma Agarwal

November 16, 2016. November 16, 2016. Their eyes clouded with lust as they looked down to where they were joined, Their movements grew urgent and fast- almost animalistic, Growing desire outed patience, As passionate kisses rendered them breathless and moans of pleasure filled the surrounding air. That night, they did not just consummate their marriage, They made love. Aroma Agarwal. July 24, 2016. July 24, 2016. July 24, 2016. July 24, 2016. June 23, 2016. July 24, 2016. She had always told her friends ...

agarwalarpit.blogspot.com

Aur Batao

Sunday, May 12, 2013. Life is always a contradiction" By Anonymous. Thursday, April 28, 2011. Tuesday, February 1, 2011. It feels good when you can let go off some memories, emotions and people when you had dared you would miss them forever" :. Monday, December 27, 2010. At times you feel you are suffering the maximum until you hear about others and you feel you are doing much better.". Monday, October 25, 2010. But are we using the word in its true sense? Infact Politics = Corruption, which is true ;).

agarwalarspackers.com

Agarwal ARS packers and movers

Packing and Moving Services. We offer end-to-end logistic cargo services to industrial clients We provide door-to-door cargo services for industrial and manufacturing companies across different sectors through Surface Cargo, Train cargo, Air cargo transportation. Agarwal ARS Packers and Movers. Specializes in offering extremely quality oriented packing, moving and transportation. Services, Loading Unloading services, Warehousing. Services, Car Carrier. Contact : Agarwal ARS Packers and Movers. Powered by...

agarwalartprinters.com

Agarwal Art Printers

Has been delivering print services sinse 1998. it's located in Balkampet, Hyderabad, India. we have vast experience in multicolour offset printing and Designing. We are one of the leading commercial printing press and specializes in all forms of offset printing i.e Catologue, Brochure, Posters, Packaging, Labels, Visual aids, Calender, and Corporate identity etc. Create and publish dynamic websites for desktop and mobile devices that meet the latest web standards without writing code. Design freely u...

agarwalash.blogspot.com

Random Thoughts

Tuesday, April 3, 2012. Nohup and background an already running process. Open a new terminal window, find the process id of the long running process and do this. Or you can also use this. This should cause the process to be suspended in the original process. now you can background it. backgrounding it alone will not cause it continue running if the window is closed. you will need to. The process is still suspended, so now resume it. Or you can also use this. Posted by Ashish Agarwal. Links to this post.

agarwalashish1989.blogspot.com

Ashish Agarwal

Saturday, June 14, 2014. Use of Script Task to create SQL table using VB.Net in SSIS. The Below Code will be useful in the cases when we need to deal with flat files, wherein the file structure may be dynamic and we are dealing with multiple files each one with a different schema definition. The approach will be here is to loop through each file and then read the first line of each file and read the column names from the file and then dynamically create the table and then load the data. Here it goes -.

agarwalassociate.com

Index of /

Apache/2.2.26 (Unix) mod ssl/2.2.26 OpenSSL/1.0.1e-fips mod bwlimited/1.4 Server at www.agarwalassociate.com Port 80.

agarwalassociates.com

Chartered Accountants India, Chartered Accountants Association, Chartered Accountants Firm

Singh Agarwal and Associates. Is a premier chartered accountancy firm in India. That offers a comprehensive range of services by chartered accountants. Including audits, corporate consultancy, advice and planning concerning tax and company law matters, as well as various outsourced activities for corporates and non-corporates. Services for an Individual. Services For An Enterprise. Company Law Advisory Services. Singh Agarwal and Associates. Developed and Managed by IndiaMART InterMESH Limited.

agarwalassociates.in

Agarwal Associates.......

Agarwal and Associates is modern technology at its finest. For more than 60 years, Agarwal and Associates has been a leading company in the offset and digital printing press industry providing the finest Digital Banners printing to clientele based in India and across the globe. Powered by Perfect K Studios.

agarwalassociatesgroup.com

Agarwal Associates Group | Aditya Builder and Developers

agarwalautosales.com

Site Under Construction

This site is under construction. Please visit again to check the status. To go back to the previous page.