First of all, my knowledge about SSIS is... equal zero!
If you want to insert values
(...)starting from 000001
and increment continuously for each row(...), it's not so simple! Why?
000001
is not a numeric value, it's a text!
The below example shows how to add/insert 1K records.
DECLARE @sNum NVARCHAR(6)
DECLARE @iNum INT
DECLARE @iCount INT
DECLARE @iCounter INT
SET @iNum = 1
SET @iCount = 1000
SET @iCounter = 1
WHILE (@iCounter <= @iCount)
BEGIN
SET @sNum = '000000'
SET @sNum = SUBSTRING(@sNum, LEN(@sNum) - LEN(CONVERT(VARCHAR(6), @iNum))+1, LEN(CONVERT(VARCHAR(6), @iNum))) + CONVERT(VARCHAR(6), @iNum)
INSERT INTO [YourTable] ([YourField]) VALUES(@sNum)
SET @iNum = @iNum + 1
SET @iCounter = @iCounter + 1
END
Results:
000001<br />
000002<br />
...<br />
001000